Data Engineering Practice Test
Data Engineering Slowly Changing Dimensions (SCDs) 2
In a Type 2 SCD, what is the primary purpose of a surrogate key on the dimension table?
Select your answer
A
To uniquely identify each historical version of a dimension record
B
To store the natural business key from the source
C
To encrypt sensitive customer data
D
To enforce referential integrity with the source system
Hint
✨ Remove Ads & Unlock Every Exam
— From $1.49
🃏 Study This Quiz as Flashcards →
