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.

Simulated

Create a single fact table with all dimensions embedded within it, updating all changes directly in the fact table.

0.0%

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.

0.0%

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.

91.7%

Avoid using slowly changing dimensions; instead, update all data in real-time without tracking changes.

8.3%

Microsoft Fabric Analytics Engineer Associate DP-600

Get started today

Comments

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.