Câu 30: DP-600: Implementing Analytics Solutions Using Microsoft Fabric

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of the solution.NOTE: Each correct answer is worth one point.

1. A. Update rows when the non-key attributes have changed. — đáp án hiện tại
2. B. Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.
3. C. Update the effective end date of rows when the non-key attribute values have changed.
4. D. Insert new records when the natural key is a new value in the table. — đáp án hiện tại