Top 50 star schema Interview Questions
The most frequently asked star schema questions across all roles and companies, ranked by real interview frequency. Updated daily.
Design Apple dimensions and a fact table, then summarize telemetry and current subscription status by device and region.
AppleAggregate completed Uber trips through normalized location dimensions and explain the star versus snowflake trade-off at scale.
UberModel a sales star schema and aggregate completed revenue by month and product category.
GlassdoorAggregate Reddit ad impressions, clicks, CTR, and unique users by platform from a dimensional model.
RedditAssign the correct chronological position to out-of-order raw events while handling ties, null timestamps, and unknown sources.
Idfc First BankDesign a star schema and produce a quarterly sales report with category revenue, order counts, rankings, and prior-month comparisons.
ArtefactDesign assessment tables and calculate respondent scores by personality dimension with PostgreSQL.
ValenceAggregate completed transaction value by customer segment and product category from dimensional warehouse tables.
Commonwealth Bank of AustraliaSign up to see every question
Create a free account to unlock this list and practice real interview questions.