Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
When implementing a Slowly Changing Dimension (SCD) Type 1 strategy in a Delta Lake table, which statement accurately describes how data updates are processed?
A
Historical changes are tracked by appending new rows for every update to maintain a full audit trail.
B
Both historical and current records are stored in the same table using an 'active' flag.
C
Existing records are overwritten with the most recent values, meaning no historical data is preserved.
D
Previous versions of the records are automatically moved to a separate archival table for storage efficiency.