Answer-first summary for fast verification
Answer: Type 2 SCD
The insurance company's method of tracking policy changes by adding new rows with `start_date`, `end_date`, and an `active` flag aligns with Type 2 SCD. This type is characterized by adding new rows to track changes over time, using effective dates to distinguish between current and historical data. Other SCD types do not match this pattern: Type 0 does not allow changes, Type 1 overwrites data, Type 3 adds columns for previous values, and Type 4 uses a separate history table, none of which are described here.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
An insurance company organizes its data to track both current and expired policies within a single table, using start_date, end_date, and an active flag (True for current, False for expired policies). What type of Slowly Changing Dimension (SCD) does this approach represent?
A
Type 0 SCD
B
Type 1 SCD
C
Type 2 SCD
D
Type 3 SCD
E
Type 4 SCD
No comments yet.