Your question is Design a Star Schema for Retail. 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).
How do you design a Star Schema for a retail dataset? What are the tables, columns, and joins used to derive the Fact table?
Asked in the 1st Round Technical Interview stage. Retail dataset star schema design.
Provide a practical design that identifies the fact-table grain, dimension tables, keys, measures, source-to-target joins, and handling of historical changes. Explain how the modeled data could support downstream analytics or ML features without introducing leakage or inconsistent definitions.