Interview Questions And Answers Forum

Ibraheem

Webmaster

From: Capital

Registered: 2012-03-16

Posts: 23,140

Website

40+ Data Architect Interview Questions And Answers

Data Structure ➔ Data Architect Job Interview Questions and Answers

Data Architect interview preparation guide for freshers and experienced professionals. Explore these number of Data Architect frequently asked questions(FAQs) extracted from many job interviews

✰ Tell us what is degenerated dimension?
✰ Explain me what do you understand by dimension and attribute?
✰ Please explain semi Additive Measures?
✰ Please explain what is dimensional modeling?
✰ What is role Playing Dimension?
✰ What is the conceptual model?
✰ Explain me what is the difference between OLTP and OLAP?
✰ Can you explain me what is dimension?
✰ Can you tell me what is SCD?
✰ What is slowly Changing Dimension (SCD)?
✰ Tell me which schema is better – star or snowflake?
✰ Explain me what is a role-playing dimension?
✰ Tell us what is data mart?
✰ Can you distinguish between OLTP and OLAP?
✰ Tell me what are the different design schemas in Data Modelling? Explain with the example?
✰ Explain me non-additive Measures?
✰ Tell us what are the benefits of data warehouse?
✰ Tell me what are the different types of dimension?
✰ What is the logical model?
✰ Tell me your idea regarding factless fact? And why do we use it?
✰ Explain me what is your understanding of different data models?
✰ Tell me what is snow-flake schema?
✰ Please explain what are the different types of dimensions you have come across? Explain each of them in detail with an example?
✰ Tell us what is a mini dimension?
✰ Can you explain me what is meant by Data Analytics?
✰ Tell us what are the different types of measures?
✰ Tell me what is junk Dimension?
✰ Can you throw some light on your experience in Data Modelling with respect to projects you have worked on till date?
✰ Do you know what is junk dimension?
✰ Tell me what is Fact?
✰ Tell me what is data warehouse?
✰ Explain me what is ER model?
✰ Tell me additive Measures?
✰ Explain me what is a 'Conformed Dimension'?
✰ Do you know what do you understand by Data Modelling?
✰ Tell me the physical data model?
✰ Tell me what is a fact & a fact table?
✰ What are conformed dimensions?
✰ Explain me what do you understand by data mart?
✰ Tell me do you know why Data Warehouse is used?

Download Data Architect Job Interview Questions And Answers PDF