Multiple choice technology

In Which Type of Slowly Changing Dimensions(SCD), Do we need to preserve history of data?

  1. TYPE 3

  2. TYPE 2

  3. TYPE 1

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SCD Type 2 preserves complete history by creating a new dimension record for each change, maintaining both current and historical data with effective date columns. Type 1 overwrites old values (no history), Type 3 tracks limited history in separate columns, and Type 0 makes no changes at all.

Keep practicing — related questions