Data Modeling & Warehousing Fundamentals
Back to Dimensional Modeling in Practice

Quiz: SCD Type 1, 2, 3 With Real Cases

The decision tree for handling dimension change. Overwrite, version, or carry-both — the choice has consequences.

8 minutesInteractive tutorial
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.
Question 1 of 10Answer saved0 answered

A customer moves from the US to India in March 2026. You want analyses to correctly attribute their past orders to the US and future orders to India. Which SCD type?

← Back to Slowly Changing Dimensions (SCDs)