Data Modeling – DE Professional Study Guide
This domain accounts for 6% of the exam and covers modeling data in the Lakehouse: dimensional models, slowly changing dimensions, and Delta table design.
Dimensional Modeling
- Fact table — measurable business events (measures like quantity and amount) plus foreign keys to dimensions (e.g., sales transactions).
- Dimension table — descriptive context to slice/filter by (customer, product, date).
- Gold-layer modeling favors a denormalized star schema (fact + dimensions) optimized for analytical reads and aggregation — not a fully normalized OLTP schema requiring many joins.
Unlock with a paid plan
3 more sections (about 133 words) continue below. Every paid plan unlocks all Data Engineer Professional study guides, the full question bank and mock exams, from $4.97/month.