Multiple choice technology databases

SCD type 2 stores ?

  1. current data

  2. historical data

  3. both

  4. none
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SCD Type 2 maintains both current and historical data by creating new rows for each change, preserving the complete history of changes. Unlike Type 1 which only keeps current data, Type 2 tracks every version of a record with effective dates or version numbers. This allows historical analysis of how values changed over time.

Keep practicing — related questions