Implementing Analytics Solutions Using Microsoft Fabric — Question 30

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.

Answer options

• 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.

Correct answer: A, D

Explanation

Option A is correct because in a Type 1 SCD, existing rows are updated directly when non-key attributes change. Option D is also correct as it indicates that new records should be added when the natural key is new, which aligns with handling new entries. Options B and C are incorrect because they do not accurately describe the Type 1 SCD process, which does not retain historical data or use effective end dates.