Answer-first summary for fast verification
Answer: Set up incremental refresh to only update data that has changed since the last refresh.
Implementing incremental refresh involves setting up policies to only update data that has changed since the last refresh, which significantly reduces the time and resources required for data updates. This approach ensures that only relevant data is processed, optimizing the refresh process without compromising data accuracy.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A logistics company uses a semantic model to track shipment data. The model is updated frequently with new shipment records, and the refresh process is becoming increasingly slow. Describe how you would implement incremental refresh to optimize this process. What are the key considerations and steps involved in setting up incremental refresh for this scenario?
A
Define a refresh policy that includes historical data only, excluding recent updates.
B
Set up incremental refresh to only update data that has changed since the last refresh.
C
Implement a full refresh every day to ensure all data is up-to-date.
D
Use incremental refresh to partition data by year, focusing on the most recent year only.