Explanation:
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.
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.