Data Modeling interview questions
Dimensional modeling and schema design: fact/dimension tables, normalization trade-offs, and modeling data so it stays queryable as it grows.
12 questions6 free to practice6 company-verified (Pro)
Free to practice
- Lakehouse Architecture for 50TB of JSON Events
- Random Projection Index for High-Dimensional Nearest Neighbor Search
- Data Quality — Diagnosing Three Trust-Eroding Incidents
- Star Schema for a Subscription SaaS Data Warehouse
- Implement dbt Column Level Lineage Tracking Snowflake Stack
- Data Quality — Preventing Three Production Incidents
Company-verified Pro
Real Data Modeling questions reported from interviews at 50+ AI companies, with the golden answer and full production scoring. Unlock with Pro →
- Feature drift detection pipeline with automated monitoring and alerting system
- Ride-level fact table with trip completion metrics and surge multipliers
- Airflow — Design an Idempotent Backfill DAG with Late-Arriving Data
- Delta Lake Time Travel: Querying Historical Table Versions
- Streaming Clickstream Lakehouse: Storage, Compaction, Queries, Schema Evolution
- Dimension table with surrogate keys tracking temporal validity ranges
Ready to practice Data Modeling?
Answer real questions in the browser and get scored on correctness, architecture, token efficiency, and security against a golden answer — not just pass/fail. Free to start.
Start practicing free →