You're designing a sales data mart for BI. Would you choose a star or a snowflake schema, and how would you decide what one row in the fact table represents?
~4 min by voice
How to approach it
This checks whether the candidate understands dimensional modeling in practice: how a star differs from a snowflake and what trade-off lies behind that, and whether they start the design with the fact table's grain rather than a list of columns.
The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.