Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.