Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Designing a Star Schema

HardPipelines00:00
Practice interviewer
In session
5 left
00:00

Your question is Designing a Star Schema. 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).

You need to log in / sign up to chat or submit.

Problem

Design a star schema database model for a global retail client tracking inventory across thousands of physical stores.

Define the grain, fact and dimension tables, surrogate-key strategy, and treatment of inventory snapshots, movements, products, stores, suppliers, dates, and currencies. Explain how the model would be populated through batch ETL, including incremental loads, late-arriving data, historical changes, reconciliation, data quality checks, and orchestration. Address query performance, partitioning, indexing, and backfills. Use a practical design with representative SQL DDL or transformation logic.