Answer-first summary for fast verification
Answer: Type 1 overwrites existing records without preserving history, whereas Type 3 stores a limited history by adding specific columns (such as `previous_value`) to the record.
In **SCD Type 1**, existing data is updated or overwritten, meaning historical values are not preserved. In contrast, **SCD Type 3** tracks limited history by adding new columns to store the previous value of a specific attribute, allowing for a side-by-side view of current and immediate-past states.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When implementing Slowly Changing Dimensions (SCD) in a Databricks Lakehouse, what is the fundamental difference between the Type 1 and Type 3 approaches?
A
Type 1 maintains a full version history of all changes, whereas Type 3 utilizes external snapshots for auditing.
B
Type 1 overwrites existing records without preserving history, whereas Type 3 stores a limited history by adding specific columns (such as previous_value) to the record.
C
Type 1 preserves historical data through versioning, while Type 3 overwrites current records with new values.
D
Type 1 archives changes in a separate audit table, while Type 3 avoids any archival of historical data.