16 important SQL Server interview questions on Data Warehousing /Data Mining – Part 2
This section is Part 2 and it will cover the most asked SQL Server interview questions by the interviewer so have a look on the following and do revise it when ever you go for the SQL Server interview
Normally SQL Server interview starts with…..
What is an OLTP (Online Transaction Processing) System?
What is an OLAP (On-line Analytical processing) system?
What is Conceptual, Logical and Physical model?
What is Data purging?
What is Analysis Services?
What are CUBES?
What are the primary ways to store data in OLAP?
What is META DATA information in Data warehousing projects?
What is multi-dimensional analysis?
What is MDX?
How did you plan your Data warehouse project?
What are different deliverables according to phases?
Can you explain how analysis service works?
What are the different problems that “Data mining” can solve?
What are different stages of “Data mining”?
What is Discrete and Continuous data in Data mining world?