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?

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 2 votes
• 3 stars: 1 votes
• 4 stars: 2 votes
• 5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!