Multiple choice technology

The following methods can be used for handling slowly changing dimensions

  1. Inserting a new field in the table

  2. Inserting a new record in the table

  3. Overwrite the existing data

  4. all of the above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Slowly Changing Dimensions (SCD) have three standard handling approaches: Type 1 overwrites existing data; Type 2 inserts new records to preserve history; Type 3 adds new fields. 'All of the above' correctly covers all three approaches plus variations. Options A, B, and C represent individual valid techniques.