WELCOME TO THE WORLD OF Data/ Data warehousing/ DB Modeling Interview Questions

Data/ Data warehousing/ DB Modeling Interview Questions–

Here I come with Data Related Questions – This will include data warehousing interview questions, analysis services interview question and modeling interview questions with some additional interview questions also. All the questions below seems to be asked in almost all the technical Interviews ranging from 2 years to 15 years of experience.

If you want me to include any question in this category please email me @ pawankkmr@gmail.com. I would be happy to include it.

Please visit T-SQL Puzzles section where we have to write the query based on the scenario given by the interviewer.

Please visit Interview Puzzles – Finding Outputs section where we have to provide the output based on the query written by the Interviewer.

Sr No	Data Interview Question
1	Data Interview Question | What is a data hub?
2	Data Interview Question | What are the differences between a Data Warehouse and a Data Hub?
3	Data Interview Question | What is a Data warehouse?
4	Data Interview Question | What is a data lake?
5	Data Interview Question | What is ODS?
6	Data Interview Question | What is ETL?
7	Data Interview Question | What is VLDB?
8	Data Interview Question | What do you mean by Dimensional Data Model?
9	Data Interview Question | What is a Star Schema?
10	Data Interview Question | What is a Snowflake Schema?
11	Data Interview Question | What are Slowly Changing Dimensions?
12	Data Interview Question | What is a Factless Fact Table?
13	Data Interview Question | What is a Conceptual Data Model?
14	Data Interview Question | What is a Logical Data Model?
15	Data Interview Question | What is a Physical Data Model?
16	Data Interview Question | Explain the differences between the Conceptual, Logical, and Physical Data Model
17	Data Interview Question | What is an OLAP?
18	Data Interview Question | What are the differences between MOLAP, ROLAP and HOLAP?
19	Data Interview Question | What are the differences between Bill Inmon vs. Ralph Kimball approaches?
20	Data Interview Question | What is a Fact? What are the types of Fact Table Types?
21	Data Interview Question | What are the types of Facts? – Additive,SemiAdditive,Non-Additive
22	Data Interview Question | What is a Junk Dimension?
23	Data Interview Question | What is a Conformed Dimension?
24	Data Interview Question | What is a degenerate dimension?
25	Data Interview Question | What are Late Arriving Dimensions? How you do handle the data in this case?
26	Data Interview Question | What are the differences between ER Modeling and Dimensional Modeling?
27	Data Interview Question | What are the difference between star and snowflake schema?
28	Data Interview Question | What is a Surrogate key?
29	Data Interview Question | What is a Data Mart?
30	Data Interview Question | What is Data Mining?
31	Data Interview Question | Can you describe the foreign key columns in fact table and dimension table?
32	Data Interview Question | What is conformed fact?