Your question is Star vs Snowflake for Meta 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).
Meta data engineers often model analytics data for products like Facebook Feed, Instagram Reels, and Ads Manager. The schema choice affects query simplicity, storage efficiency, and how easy it is to maintain dimensions over time.
Compare star schema and snowflake schema in a warehouse or analytics environment. Explain:
Keep the answer practical. The interviewer is looking for a clear comparison, not textbook definitions only. Discuss how the choice impacts SQL query complexity, BI/reporting use cases, and dimension management at scale. If helpful, reference fact tables, dimension tables, and common analytical joins.