Answer-first summary for fast verification
Answer: Increased storage requirements resulting from the retention of historical record versions.
SCD Type 2 tables are designed to maintain a comprehensive history of changes by creating a new row for every update (versioning). While this provides historical lineage and enables point-in-time reporting, the primary trade-off is the **increased storage consumption** compared to SCD Type 1, where existing records are simply overwritten.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When implementing Slowly Changing Dimensions (SCD) Type 2 tables within a data architecture, which of the following is considered a primary trade-off?
A
Loss of historical context because records are overwritten during updates.
B
Increased storage requirements resulting from the retention of historical record versions.
C
Simplified deduplication logic that reduces the complexity of incremental loads.
D
Reduced query performance caused specifically by the inherent requirement for complex self-joins.