pl-300 Practice Question 1938
Exam: pl-300
Domain: Deploy and maintain assets
Topic: Manage files and datasets
Difficulty: medium
Your organization uses Azure Synapse Analytics and you need to perform an incremental refresh on a dataset to update only the new or modified records since the last refresh. Which method should you use to achieve this?
You have a dataset named `CustomerOrders` and you want to ensure that only the new or updated orders since the last refresh are added to the dataset.
Answer Options
A
Perform a full refresh of the dataset.
B
Use the incremental refresh method to update only the new or modified records.
C
Manually update the dataset by inserting new records.
D
Configure the dataset to automatically update records based on timestamps.
Correct Answer
B: Use the incremental refresh method to update only the new or modified records.
Explanation
Incremental refresh is a feature in Azure Synapse Analytics that allows you to update only the new or modified records in a dataset since the last refresh. By using the incremental refresh method, you can efficiently update the `CustomerOrders` dataset with only the new or updated orders, without having to reprocess the entire dataset. Other methods like full refresh or manual updates would process the entire dataset, which could be inefficient if only a small portion of the data has changed.