Data Modeling Interview Questions

4,819 data modeling interview questions shared by candidates

What is the difference between conceptual, logical, and physical data models? Explain normalization vs denormalization with examples. Types of relationships (1:1, 1:N, M:N) and how to model them. What are slowly changing dimensions (SCDs) in dimensional modeling? Star schema vs snowflake schema. What is a surrogate key vs natural key?
avatar

Data Modeler

Interviewed at Capgemini

4.2
Jul 1, 2025

What is the difference between conceptual, logical, and physical data models? Explain normalization vs denormalization with examples. Types of relationships (1:1, 1:N, M:N) and how to model them. What are slowly changing dimensions (SCDs) in dimensional modeling? Star schema vs snowflake schema. What is a surrogate key vs natural key?

Viewing 231 - 240 interview questions

Glassdoor has 4,819 interview questions and reports from Data modeling interviews. Prepare for your interview. Get hired. Love your job.