Data Modeling

Data modeling questions test your understanding of how data should be structured for downstream use. At most companies, the model you build becomes the foundation that analysts, dashboards, and ML features depend on for years.

Interviewers want to see that you understand the trade-offs between normalized and denormalized schemas, when to use star vs snowflake vs wide flat tables, and how to handle slowly changing dimensions, late-arriving data, and schema evolution gracefully.