Data Engineering
Data Modeling & Warehousing
6 practice questions. Free questions open a full answer guide; the rest unlock with Pro.
- What is the difference between a fact table and a dimension table in a star schema, and how does a star schema compare to a snowflake schema?
- What is a slowly changing dimension, and how does a Type 2 SCD preserve history in a warehouse?Go Pro
- A business stakeholder needs to report on a customer attribute like sales region as it was at the time of each historical order, but your dimension table only stores the customer's current region. How do you model the warehouse so history is preserved correctly?Go Pro
- Why are analytical data warehouses usually modelled as denormalized star schemas rather than the normalized 3NF design you'd use for a transactional database? Walk me through the trade-off.Go Pro
- A dimension attribute like a customer's address or sales region changes over time. How would you model that so historical facts still tie to the value that was correct when the event happened?Go Pro
- You're standing up the warehouse data model for a new analytics platform and the team is debating a Kimball star schema, Data Vault, and a single wide one-big-table approach. How do you reason about that choice?Go Pro
Want questions matched to your role? Paste a job title, job description, or CV for a personalized set, or go Pro to unlock the full bank.