DP-600 - Prepare Data - Section 2.5

Implement a star schema for a lakehouse or warehouse and enrich data by adding columns or tables, denormalising, and aggregating.

Design a star schema with fact and dimension tables using surrogate keys to optimise analytical query performance in a Lakehouse or Warehouse. Enrich the model by adding derived columns, pre-aggregated tables, and denormalised attributes that reduce join complexity at query time.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.