Ultimate access to all questions.
Answer-first summary for fast verification
Answer: Type 2
## Explanation **Type 2 SCD (Slowly Changing Dimension)** is the correct choice because it maintains a complete history of changes by creating new records rather than updating existing ones. ### Key Characteristics of Type 2 SCD: - **Preserves History**: When data changes, Type 2 creates a new record with the updated values while keeping the old record intact - **Audit Trail**: Provides a complete audit trail of all changes over time - **Effective Dating**: Typically includes start_date and end_date columns to track when each version was valid - **Current Flag**: Often includes a flag to identify the current active record ### Why Other Options Are Incorrect: - **Type 0**: Retains original values permanently - no updates allowed - **Type 1**: Overwrites old data with new data - no history preserved - **Type 1 or Type 2**: Type 1 does NOT preserve history, so this combination is incorrect ### Use Case Fit: The requirement for "access to a recorded history of the information previously stored" directly aligns with Type 2 SCD functionality, making it the ideal choice for scenarios where historical tracking and auditability are required.
Author: LeetQuiz .
No comments yet.
A data engineer has data that needs to be updated. However, they need to have access to a recorded history of the information previously stored in the dataset before the update. Which of the following table types should the data engineer use for their data?
A
Type 0
B
Type 1
C
Type 2
D
Type 1 or Type 2