MSBI Interview Questions with Answers

MSBI Interview Questions & Answers :-

• 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)?
• 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?
• 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?
• 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?
• Question 36 :- What is CDC?
• Question 37 :- 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 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.
• Question 42 :- How to Create Cascade Parameters in SSRS Report ?
• Question 43 :- How to define clickable areas in SSRS Report?