Here is the list of top advanced data modeling interview questions you must prepare for any data modeler interview and also for any data warehouse related job interview.
What is the purpose and benefits of data warehouse?
What is the Process to Create a Data Warehouse?
What are difference methodologies of data warehouse design?
What are the differences between an Entity Relational and Dimensional Model ?
What is data mart, Dimensions and Facts?
What are the different types of dimensions and Fact Tables?
What is Star-schema?
What are the major differences between a Star-schema and Snow-Flake designs?
What is data sparsity and how it effect on aggregation?
When should you consider de-normalization?
What are the differences between OLAP and OLTP?
keywords – erwin data modeler interview questions and answers, data architect interview questions and answers, data warehousing concepts interview questions answers, data warehouse interview questions and answers, enterprise data architect interview questions, database design and implementation: a practical introduction using oracle sql by bookboon, business intelligence interview questions and answers, advanced data warehouse interview questions