Answer-first summary for fast verification
Answer: SCD Type 2
Slowly Changing Dimension (SCD) Type 2 is the standard approach for tracking historical data in Delta Lake. Unlike SCD Type 1, which overwrites existing values, SCD Type 2 adds new rows for every change, typically utilizing effective dates or status flags to distinguish between current and historical records, thus providing a comprehensive audit trail.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the context of Delta Lake data architecture, which Slowly Changing Dimension (SCD) type is designed to maintain a full history of changes by storing both historical and current records within the same table?
A
SCD Type 0
B
SCD Type 3
C
SCD Type 1
D
SCD Type 2
No comments yet.