03rd
Feb

MSBI MCQ

Admin
03rd Feb, 2023
875 Followers

MSBI MCQ
MSBI MCQ PDF

MSBI MCQ Questions

1. MSBI is an abbreviated form of ____.
2. ___ helps in providing best solutions for Business Intelligence and Data Mining Queries.
3. The three MSBI tools are ____.
4. SSIS is abbreviated as ____.
5. What is the difference between UNION and UNION ALL?
6. What are different types of joins?
7. Stored procedure offers a ___.
8. What does mean by data auditing?
9. What are the options to deploy SSAS cube in production?
10. SSAS is abbreviated as _____.
11. SSAS is used to build ___.
12. OLAP stands for ____.
13. What is Multi-Dimensional expression?
14. ETL refers to the ___.
15. Difference between for loop and for each loop container?
16. Define synchronous transformations?
17. What is the usage of Report Builder?
18. A ___ is basically a set of instructions that is shared with the Program Executor as a guideline to execute tasks and containers.
19. What do you mean by ControlFlow?
20. SSIS architecture involves ___.

Take MSBI MCQ Quiz & Online Test to Test your Knowledge

We have listed below the few MSBI MCQ Questions that check your basic knowledge of MSBI. This MSBI MCQ Test contains 20 Multiple Choice Questions. You have to select the right answer to the question. Apart from this, you can also download MSBI MCQ Pdf, completely free.

MSBI MCQ Online Test

1) MSBI is an abbreviated form of ____.

A. Microsoft Business Intelligence
B.Microsoft Business Information
C.Microsoft Buket Intelligence
D.None of the above

2) ___ helps in providing best solutions for Business Intelligence and Data Mining Queries.

A. MSBI
B.MSSI
C.MCQI
D.All of the above

3) The three MSBI tools are ____.

A. SSIS – SQL Server Integration Services.
B.SSAS – SQL Server Analytical Services.
C.SSRS – SQL Server Reporting Services.
D.All of the above

4) SSIS is abbreviated as ____.

A. SQL Server Integration Service
B.SQL Server Information Service
C.SQL Integration Service
D.None of the above

5) What is the difference between UNION and UNION ALL?

A. Union selects only unique row (data) from all queries and Union all selects all rows from all queries.
B.Union selects row (data) from all queries and Union all selects all rows from all queries.
C.Union selects only unique row (data) from all queries and Union all selects rows from all queries.
D.Union selects row (data) from all queries and Union all selects rows from all queries.

Download Free : MSBI MCQ PDF

6) What are different types of joins?

A. Inner, outer, self join
B.Equi join and cross join
C.Right outer join.
D.All of the above

7) Stored procedure offers a ___.

A. Pre executable program
B.We can get the data
C.Security
D.It is similar to function.

8) What does mean by data auditing?

A. To maintain data load statistics in ETL process.
B.To know the errors.
C.To know the Primary keys.
D.None of the above

9) What are the options to deploy SSAS cube in production?

A. Using BIDS.
B.Using SSMS.
C.Using XMLA.
D.All of the above

10) SSAS is abbreviated as _____.

A. SQL Server Analysis Services
B.SQL Analysis Services
C.SQT Server Analysis Services
D.All of the above

11) SSAS is used to build ___.

A. OFAPS/offline analytical processing
B.OLAPS/online analytical processing
C.OFAPS/offline analysis processing
D.All of the above

12) OLAP stands for ____.

A. Online analytical processing
B.Offline analytical processing
C.Online analytical paper
D.None of the above

13) What is Multi-Dimensional expression?

A. A language created to allow the users to work with Multi-Dimensional data in Microsoft SQL Server Analysis Services.
B.Multi-Dimensional expression (MDX) is a database.
C.Multi-Dimensional expression (MDX) is a sql.
D.All of the above

14) ETL refers to the ___.

A. Extract Translation Loading.
B.Extract Transformation Loading
C.Both a and b.
D.None of the above

15) Difference between for loop and for each loop container?

A. For loop based on conditions and for each loop based on objects collections.
B.For loop based on objects collections and for each loop based on objects collections.
C.Both a and b.
D.None of the above

16) Define synchronous transformations?

A. Input rows count and Output rows count are the same.
B.Input rows count and Output rows count are not the same.
C.Input rows count and Output rows count are different.
D.None of the above

17) What is the usage of Report Builder?

A. To create reports.
B.To create reports for users.
C.Business users create reports.
D.None of the above

18) A ___ is basically a set of instructions that is shared with the Program Executor as a guideline to execute tasks and containers.

A. Workflow
B.Controlflow
C.UserFlow
D.None of the above

19) What do you mean by ControlFlow?

A. A control flow mostly consists of one or more tasks and containers that execute when a package is run.
B.A control flow execute when a package created.
C.program
D.None of the above