Data warehouse Interview Questions

Q1. Explain about Star Schema.
Q2. Explain about Snow-Flake Schema.
Q3. Explain the situation where Snow-Flake is better than Star-Schema.
Q4. Name 2-3 different Data Modeling Tools with versions.
Q5. Name 10-15 different tools related to Data Warehousing.
Q6. What is Relational Modeling?
Q7. What is Dimensional Modeling?
Q8. What is the basic difference between Relational vs Dimensional Modeling?
Q9. What is the difference between Bill Inmon and Ralph Kimball data warehousing concepts?
Q10. What are the fact measure types?
Q11. What is the difference between Star-Schema and Snow-Flake? Which one is good?
Q12. Explain about Slow Changing Dimensions (SED) and its types with examples.
Q13. What are the different phases of Data Warehouse?
Q14. Explain about Facts and Dimensions with examples.
Q15. Explain about Data Warehousing? Why do we need Data Warehousing?
Q16. What is the difference between Data Warehouse and data Mart?
Q17. What is the difference between Data Warehousing testing vs Data Mart testing?
Q18. What is OLAP?
Q19. What is OLTP?
Q20. What is the basic difference between OLAP vs OLTP?
Q21. What is ODS?
Q22. What is staging? What is Target?
Q23. What is ETL? What is BI?
Q24. What is Master Data Management? What tools are used for MDM?
Q25. What is Data profiling?
Q26. What is Data Cleaning and Data Scrubbing?
Q27. What is Data Stewardship?
Q28. Describe a typical Data Warehousing architecture.
Q29. Explain about Normalization and De-Normalization
Q30. Explain about views and materialized views.
Q31. Explain about Database constraints.
Q32. Name few Dimension tables and Fact tables.