Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
In the context of creating a data loading pattern for a Type 1 Slowly Changing Dimension (SCD), which primarily involves updating the existing records without keeping any historical data, which two actions should be included in the process? Each correct answer represents a portion of the complete solution. NOTE: Each correct answer is worth one point.
A
Update rows when the non-key attributes have changed.
B
Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.
C
Update the effective end date of rows when the non-key attribute values have changed.
D
Insert new records when the natural key is a new value in the table.