Explanation:
Option C correctly addresses the need for both Type 1 and Type 2 slowly changing dimensions in a star schema. This approach allows for immediate updates where necessary (Type 1) and historical tracking (Type 2), which is essential for maintaining data integrity and historical context.
Ultimate access to all questions.
Consider a scenario where you need to implement a star schema for a lakehouse that includes both Type 1 and Type 2 slowly changing dimensions. Describe how you would design this schema, including the tables, their relationships, and how you would manage changes in the data over time.
A
Create a single fact table with all dimensions embedded within it, updating all changes directly in the fact table.
B
Design a star schema with a fact table and separate dimension tables, using Type 1 for all dimensions to overwrite old data with new data.
C
Design a star schema with a fact table and separate dimension tables, using Type 1 for immediate updates and Type 2 for historical tracking by adding new rows.
D
Avoid using slowly changing dimensions; instead, update all data in real-time without tracking changes.
No comments yet.