If you're looking for MSBI Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research By 2020, predictive and prescriptive analytics will attract 40% of enterprises net new investment in business intelligence and analytics.. So, You still have opportunity to move ahead in your career in MSBI Development. Mindmajix offers Advanced MSBI Interview Questions 2019 that helps you in cracking your interview & acquire dream career as MSBI Developer.
Q. What is MSBI (Microsoft Business Intelligence)?
Microsoft Business Intelligence (BI) is a suite of products and tools that you can use to monitor, analyze and plan your business by using scorecards, dashboards, management reporting and analytics.
Q. What are the tools in MSBI?
It contains the following tools:
- SQL Server Analysis Services (SSAS)
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- Performance Point Services (PPS) which was added as a free service in Microsoft Office SharePoint 2010
SSIS – SQL Server Integration Services
Q. What is SSIS? How it is related with SQL Server.
SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server.
This is a platform for Integration and Workflow applications. It is known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and multidimensional data sets.
Q. What are the tools associated with SSIS?
We use Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) to work with Development of SSIS Projects.
We use SSMS to manage the SSIS Packages and Projects.
Q. What are the differences between DTS and SSIS
Data Transformation Services SQL Server Integration Services
Limited Error Handling Complex and powerful Error Handling
Message Boxes in ActiveX Scripts Message Boxes in .NET Scripting
No Deployment Wizard Interactive Deployment Wizard
Limited Set of Transformation Good number of Transformations
NO BI functionality Complete BI Integration
Q. What is a workflow in SSIS 2014?
Workflow is a set of instructions on to specify the Program Executor on how to execute tasks and containers within SSIS Packages.
Q. What is the control flow?
A control flow consists of one or more tasks and containers that execute when the package runs. To control order or define the conditions for running the next task or container in the package control flow, we use precedence constraints to connect the tasks and containers in a package. A subset of tasks and containers can also be grouped and run repeatedly as a unit within the package control flow. SQL Server Integration Services (SSIS) provides three different types of control flow elements: Containers that provide structures in packages, Tasks that provide functionality, and Precedence Constraints that connect the executables, containers, and tasks into an ordered control flow.
For more info please visit Mindmajix.