Welcome to your interview.
The question is on your right: Star vs Snowflake for Sales Analytics. Take a moment with it first.
Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.
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.