What will students learn in your course?
- This course contains practical MSBI Interview Questions with Answers.
- MSBI Interview Questions around SSIS Data Flow, Control Data Flow, ETL Process, SSIS Architecture, SSIS Perfmon Counters, SSIS lookup component.
- Error Handling in SSIS, SSIS Containers, Deploy SSIS package to SQL Server, Transactions and CheckPoints
- SSIS logging, File System Deployment, Union all, Merge, Data Profiling Task, Precedence Constraints.
What are the requirements or prerequisites for taking your course?
- Basic Knowledge of SQL Server
Who is this course for?
- MSBI Developers who are looking to crack MSBI Interviews
- SSIS developers who want to crack SSIS interviews
- SSAS developers who want to crack MSBI Interviews
- SSRS developer who want to crack SSRS interviews
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?