Your question is Star vs Snowflake for Sales Analytics. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
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.