New
MSBI , SSIS,SSAS and SSRS Interview Questions & Answers
MSBI Interview Questions & Answers covers Interview questions around SSIS,SSAS and SSRS
Instructor
QuestIT Pvt limited
1,102
Students
enrolled
- Description
- Curriculum
- FAQ
- Reviews
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.
Questions on Error Handling, SSIS Containers, Deploy SSIS Package.
Questions on SSIS Logging, Union All vs Merge, Data Profiling Task.
Questions on Joins in MSBI, OLAP VS OLTP, Star Schema, Snow Flake, SSAS Cube.
Questions on CDC, SSRS Report, Tabular Report, Matrix Report and Page Break.
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!
Please, login to leave a review
Course details
Video
4 hours
Lectures
1
Certificate of Completion
Full lifetime access
Access on mobile and TV
Popular courses
