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?

Question 6: SSIS Variables vs Parameters?

Question 7: How to Schedule SQL Server Integration Services (SSIS) Package?

Question 8: How to pass variable as a parameter in Execute SQL Task SSIS?

Question 9: How to send mails in SSIS?

Question 10: SSIS Pivot and Unpivot?

Question 11: What is Aggregation in SSAS?

Question 12: What are Partitions in SSAS?

Question 13: Explain Types of SSAS Storage Modes?

Question 14: SSAS Relationships Types?

Question 15: Named calculation vs Named query in SSAS?

Question 16: What are the different data regions in SSRS?

Question 17: How to Create Multi Valued Parameterized Report in SSRS?

Question 18:  Explain the different types of reports in SSRS?

Question 19: How to send Automatic Report Delivery in SSRS?

Question 20: Mention some of the open source softwares which are an alternative to SQL Server Reporting Services (SSRS)?

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

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

• Question 22- Types of Containers in SSIS.

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

• Question 24 - What are Transactions?

• Question 25 - What are Checkpoints?

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

• Question 26 : What is Logging in SSIS?

• Question 27 : How to create File System Deployment?

• Question 28 : Difference between Merge and Union All?

• Question 29 : What is the Data Profiling task?

• Question 30 : What is Precedence Constraints?

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

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

• Question 32 : Difference between OLTP & OLAP.

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

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

• Question 35 : What is SCD?

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

• Question 36 :- What is CDC?

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

• Question 38 :- How to Deploy SSRS reports?

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

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

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

Explain creating cascade parameters and defining clickable areas in SSRS Reports?

• Question 42 :- How to Create Cascade Parameters in SSRS Report ?

• Question 43 :- How to define clickable areas in SSRS Report?