Answer-first summary for fast verification
Answer: SCD Type 1
In a Type 1 SCD table, the new data overwrites the existing data, resulting in the loss of the original information as it is not stored elsewhere. This behavior is characteristic of SCD Type 1. For instance, a `customers_silver` table designed as a Type 1 SCD would only retain the most recent valid information for each customer. Reference: [Slowly Changing Dimension - Wikipedia](https://en.wikipedia.org/wiki/Slowly_changing_dimension)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When comparing two versions of a Delta Lake table before and after an update, which Slowly Changing Dimension (SCD) Type does this table represent?
| user_id | name | address | city |
|---|---|---|---|
| 001 | John | 4, Oxford Street | London |
| 002 | Sarah | 99, Victor Hugo Street | Paris |
| user_id | name | address | city |
|---|---|---|---|
| 001 | John | 25, King's Road | London |
| 002 | Sarah | 99, Victor Hugo Street | Paris |
A
It's a combination of Type 0 and Type 2 SCDs
B
SCD Type 1
C
More information is needed to determine the SCD Type of this table
D
SCD Type 0
E
SCD Type 2
No comments yet.