Data Engineering on Microsoft Azure — Question 32

You are designing a dimension table for a data warehouse. The table will track the value of the dimension attributes over time and preserve the history of the data by adding new rows as the data changes.
Which type of slowly changing dimension (SCD) should you use?

Answer options

• A. Type 0
• B. Type 1
• C. Type 2
• D. Type 3

Correct answer: C

Explanation

Type 2 slowly changing dimensions are specifically designed to retain historical data by creating a new row for each change. Type 0 does not track changes, Type 1 overwrites old data without preserving history, and Type 3 allows for limited historical tracking but does not add new rows for each change.