Microsoft Dynamics 365 Customer Insights – Data — Question 24
You are selecting the data sources for an incremental refresh.
You need to set up the incremental refresh for qualified data sources.
Which two points must you consider before doing the refresh? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Answer options
- A. To set up a data source for incremental refresh in Dynamics 365 Customer Insights a user must be able to select the primary key for the table or the entities within the data source to complete configuration of the incremental refresh schedule.
- B. Once a data source is ingested in Microsoft Dynamics 365 Customer Insights it can be set up for incremental refresh if the data is being updated in the source system and can be refreshed in Dynamics 365 Customer Insights on a defined schedule.
- C. The user can set up an incremental refresh for the existing data source as long as it supports incremental updates. The data is ingested through Microsoft Power Query, and the table must have fields that contain a lastupdated date and a primary key.
- D. The initial refresh for a data source configured for an incremental refresh will be a full refresh. All subsequent data refreshes will only update records in Dynamics 365 Customer insights based on inserts, updates and deletes in the data source.
Correct answer: C, D
Explanation
Option C is correct because it outlines the necessary conditions for a data source to support incremental refresh, specifically mentioning the need for a lastupdated date and a primary key. Option D correctly states that the initial refresh will be a full refresh, with subsequent updates based on changes in the source data. Options A and B do not fully address the requirements for incremental refresh and are therefore incorrect.