Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
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?
Exam-Like
Community
LLeetQuiz
Explanation:
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.
Comments
Loading comments...