Answer-first summary for fast verification
Answer: Increased storage consumption resulting from the preservation of all historical versions of a record.
The primary trade-off of implementing **SCD Type 2** is **increased storage requirements**. Unlike SCD Type 1, which overwrites existing data, SCD Type 2 tracks history by adding new records for every change (maintaining both the current state and all previous states). While this allows for detailed historical analysis and point-in-time reporting, it results in a much larger table footprint over time as historical versions accumulate.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When implementing Slowly Changing Dimension (SCD) Type 2 tables within a data warehouse, which of the following is considered a primary trade-off?
A
A significant decrease in query performance caused by the mandatory use of complex broadcast joins.
B
Loss of historical context because existing records are overwritten by updated values.
C
Increased storage consumption resulting from the preservation of all historical versions of a record.
D
The requirement to implement complex deduplication logic during the initial bronze layer ingestion.
No comments yet.