
Ultimate access to all questions.
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.