MSBI , SSIS,SSAS and SSRS Interview Questions & Answers

Prepare for MSBI Interview with over 25 questions and answers with practical demonstrations :-

Questions on ETL Process, SSIS Control Flow and other SSIS concepts :-

• Question 1 - What is ETL Process with example?

• Question 2 - Difference between control flow and data flow in SSIS?

• Question 3 - Explain the architecture of SSIS?

• Question 4 - Explain the types of Perfmon counters for SSIS?

• Question 5 - Explain the types of Cache Mode in SSIS Lookup component?

Questions on Error Handling, SSIS Containers, Deploy SSIS Package :-

• Question 6 - How to do Error Handling in SSIS.

• Question 7 - Types of Containers in SSIS.

• Question 8 - How to do SSIS Package Deployment to SQL Server?

• Question 9 - What are Transactions?

• Question 10 - What are Checkpoints?

Questions on SSIS Logging, Union All vs Merge, Data Profiling Task :-

• Question 11 : What is Logging in SSIS?

• Question 12 : How to create File System Deployment?

• Question 13 : Difference between Merge and Union All?

• Question 14 : What is the Data Profiling task?

• Question 15 : What is Precedence Constraints?

Questions on Joins in MSBI, OLAP VS OLTP, Star Schema, Snow Flake, SSAS Cube :-

• Question 16 : What is Merge Join and explain its different types of Joins?

• Question 17 : Difference between OLTP & OLAP.

• Question 18 : What is Fact, Dimension, Cube, Star Schema and Snow Flake?

• Question 19 : How to create a Cube in SSAS?

• Question 20 : What is SCD?

Questions on CDC, SSRS Report, Tabular Report, Matrix Report and Page Break :-

• Question 21 :- What is CDC?

• Question 22 :- What is SSRS, what is Data Region, can embed/display SSRS Reports in any application, File extension and Code behind of SSRS Report.

• Question 23 :- How to Deploy SSRS reports?

• Question 24 :- Difference between Tabular and Matrix Report.

• Question 25 :- What is Page Break in SSRS?

• Question 26 :- Difference between Drilldown Report & Sub Report.