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