Data modeling interview questionsTechnical interview questions
← Interview & exam prep
Technical interview questions

Data modeling interview questions

13 questions from beginner to advanced, each with the correct answer and a one-line explanation of why. Study them here, or take them as a timed test.

13 questionsBeginner 7 · Intermediate 6Answers + explanations
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Beginner 7 questions

1A star schema consists of…

  1. Two fact tables joined directly
  2. Only one flat table
  3. Normalized 3NF tables
  4. Many linked fact tables
  5. A central fact table linked to dimension tables
Show answerHide answer

E · A central fact table linked to dimension tables A star has one fact table surrounded by descriptive dimension tables.

2Numeric, additive values (sales, quantity) belong in…

  1. A slicer
  2. A dimension table
  3. The Date table
  4. A measure table only
  5. The fact table
Show answerHide answer

E · The fact table Facts (measurable events) live in the fact table; descriptive attributes live in dimensions.

3The 'grain' of a fact table is…

  1. The level of detail one row represents
  2. Its refresh schedule
  3. Its sort order
  4. Its number of columns
  5. Its storage mode
Show answerHide answer

A · The level of detail one row represents Grain defines what a single row means (e.g., one row per order line).

4A snowflake schema differs from a star because its dimensions are…

  1. Normalized into several related tables
  2. Removed
  3. Stored as facts
  4. Bidirectional
  5. Denormalized into one table
Show answerHide answer

A · Normalized into several related tables Snowflaking normalizes dimensions into multiple related tables.

5A surrogate key is…

  1. A business/natural key
  2. A system-generated key with no business meaning
  3. A slicer
  4. A measure
  5. A relationship
Show answerHide answer

B · A system-generated key with no business meaning Surrogate keys are stable, model-generated identifiers used for relationships.

6The recommended relationship cardinality from a dimension to a fact is…

  1. No relationship
  2. Many-to-many
  3. Bidirectional by default
  4. One-to-many (single direction)
  5. One-to-one
Show answerHide answer

D · One-to-many (single direction) One dimension row relates to many fact rows, filtering in a single direction.

7A dedicated Date dimension is recommended so that…

  1. Files are smaller
  2. RLS is enabled
  3. Refresh is faster
  4. Visuals are prettier
  5. Time-intelligence and consistent date attributes work
Show answerHide answer

E · Time-intelligence and consistent date attributes work A marked Date table gives a continuous calendar for time-intelligence and reusable date attributes.

Intermediate 6 questions

8A role-playing dimension (Date used for Order and Ship date) is handled with…

  1. Deleting one date
  2. Inactive relationships + USERELATIONSHIP, or duplicate date tables
  3. A bridge table
  4. Bidirectional filtering
  5. One relationship only
Show answerHide answer

B · Inactive relationships + USERELATIONSHIP, or duplicate date tables Keep one active relationship and activate the other per-measure with USERELATIONSHIP, or use a second date table.

9A true many-to-many between two dimensions is best resolved with…

  1. Bidirectional filters everywhere
  2. Merging them into one
  3. A calculated column
  4. A bridge (junction) table
  5. Removing the relationship
Show answerHide answer

D · A bridge (junction) table A bridge table models the M:N relationship cleanly and predictably.

10A degenerate dimension is…

  1. An unused table
  2. A dimension attribute stored in the fact table (e.g., order number)
  3. A snowflake
  4. A measure
  5. A broken relationship
Show answerHide answer

B · A dimension attribute stored in the fact table (e.g., order number) Degenerate dimensions (like transaction IDs) live in the fact table with no separate dimension.

11Bidirectional cross-filtering is risky because it can cause…

  1. Smaller files
  2. Automatic RLS
  3. Ambiguous filter paths and performance issues
  4. Faster refresh
  5. Better compression
Show answerHide answer

C · Ambiguous filter paths and performance issues Two-way filters can create ambiguity and slow queries; use sparingly and deliberately.

12A Slowly Changing Dimension Type 2 preserves history by…

  1. Deleting old rows
  2. Storing history in the fact
  3. Overwriting the value
  4. Ignoring changes
  5. Adding a new row (versioned) for each change
Show answerHide answer

E · Adding a new row (versioned) for each change SCD Type 2 inserts a new versioned row so historical facts keep their original attribute values.

13A conformed dimension is one that…

  1. Belongs to a single report
  2. Cannot be filtered
  3. Has no keys
  4. Is always bidirectional
  5. Is shared consistently across multiple fact tables
Show answerHide answer

E · Is shared consistently across multiple fact tables Conformed dimensions (e.g., a shared Date or Customer) allow consistent analysis across facts.

What changed lately? Latest Data Modeling news, releases & questions →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More technical interview questions