Interview Guides
Dimensional modeling choices affect how easily analysts can query data and how efficiently a warehouse supports reporting. In a sales environment such as Coca-Cola Consolidated reporting, this often comes down to choosing between a star schema and a snowflake schema.
You are asked to explain the difference between a star schema and a snowflake schema. Describe how fact tables and dimension tables are organized in each model, what role normalization plays, and how those choices affect query simplicity, storage, maintainability, and performance.
A strong answer should define both schemas clearly, compare them directly, and explain when you would choose one over the other in a practical analytics setting. You should also mention common trade-offs rather than treating one model as universally better.
