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.
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.
No comments yet.