Answer-first summary for fast verification
Answer: Existing records are overwritten with the most recent values, meaning no historical data is preserved.
In an **SCD Type 1** implementation, the table is updated to reflect the most current state of the data. When a change occurs, the existing record is overwritten with the new information. This method is used when historical tracking is not required, as it discards previous values in favor of the latest available data. In Delta Lake, this is typically performed using the `MERGE` command.
Author: LeetQuiz Editorial Team
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.
No comments yet.