Fabric Analytics Engineer (DP-600) · Free practice question 12 of 12
Detect data changes in incremental refresh
An incremental refresh policy refreshes the last 10 days of the Orders table on every run. Most days don't change, but some older days within the window are corrected occasionally. The source has a LastModified audit column. How can you refresh only the days whose data changed?
- A.Enable Only refresh complete days
- B.Enable Get the latest data in real time with DirectQuery
- C.Reduce the archive period to 10 days
- D.Enable Detect data changes and select the LastModified column
Show answer and explanation
Correct answer: D. Enable Detect data changes and select the LastModified column
Why: Detect data changes evaluates the maximum value of a chosen date/time column, such as an audit timestamp, for each period in the incremental window and refreshes only the periods where that value changed. The column should differ from the one used to filter on RangeStart and RangeEnd. Only refresh complete days controls partial-day handling, the real-time option adds a DirectQuery partition, and shortening the archive period deletes history.
More free Fabric Analytics Engineer (DP-600) questions
- Reviewing access in the catalog Secure tab
- Shortcut caching for cross-cloud egress
- Open mirroring landing zone for custom sources
- Distinct and conditional counts in KQL
- Converting strings to dates in PySpark
- Warehouse replacements for unsupported types
- Top item value with the INDEX function
- Calculated columns in Direct Lake models
- Diagnosing fallback with TABLETRAITS
- Default lakehouse rules for notebooks
- Opening PBIP projects without a pbip file