Friday, 30 January 2015

40 TOP MSBI Interview Questions and Answers for freshers and experienced pdf free download

1. What is MS BI (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.

2. What are the tools in MS BI?
It contains the following tools:
? SQL Server Analysis Services (SSAS)
? SQL Server Integration Services (SSIS)
? SQL Server Reporting Services (SSRS)
? PerformancePoint Services (PPS) which was added as a free service in Microsoft Office SharePoint 2010

3. What is SSIS? How it 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.

4. 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.

5. 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

6. What is a workflow in SSIS ?
Workflow is a set of instructions on to specify the Program Executor on how to execute tasks and containers within SSIS Packages.
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5  Part6  Part7  Part8

No comments:

Post a Comment