Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are designing a dimension table for a data warehouse that will track changes to dimension attributes over time by adding a new row for each change to preserve the full history. Which type of slowly changing dimension (SCD) should you use?
A
Type 0
B
Type 1
C
Type 2
D
Type 3