Intermediate Big Data & Data Engineering
Q51 / 100

In dimensional modeling, what is a "Slowly Changing Dimension" (SCD) Type 2?

Correct! Well done.

Incorrect.

The correct answer is A) A technique that preserves historical values by adding new rows with effective date ranges when a dimension attribute changes

A

Correct Answer

A technique that preserves historical values by adding new rows with effective date ranges when a dimension attribute changes

Explanation

SCD Type 2 tracks history by inserting new rows (with start/end dates or a current flag) instead of overwriting, unlike Type 1 which simply overwrites.

Previous All Questions Next
Progress
51/100
📊

Browse All Big Data & Data Engineering Questions

100 questions · beginner to advanced