MSBI MCQ Online Test

  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 ___.
MSBI MCQ

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. You can also take the online quiz from the take MSBI Quiz Button.

  • Microsoft Business Intelligence
  • Microsoft Business Information
  • Microsoft Buket Intelligence
  • None of the above
View Answer
  • MSBI
  • MSSI
  • MCQI
  • All of the above
  • SSIS – SQL Server Integration Services.
  • SSAS – SQL Server Analytical Services.
  • SSRS – SQL Server Reporting Services.
  • All of the above
View Answer
  • SQL Server Integration Service
  • SQL Server Information Service
  • SQL Integration Service
  • None of the above
View Answer
  • Union selects only unique row (data) from all queries and Union all selects all rows from all queries.
  • Union selects row (data) from all queries and Union all selects all rows from all queries.
  • Union selects only unique row (data) from all queries and Union all selects rows from all queries.
  • Union selects row (data) from all queries and Union all selects rows from all queries.
Download Free : MSBI MCQ PDF
View Answer
  • Inner, outer, self join
  • Equi join and cross join
  • Right outer join.
  • All of the above
View Answer
  • Pre executable program
  • We can get the data
  • Security
  • It is similar to function.
View Answer
  • To maintain data load statistics in ETL process.
  • To know the errors.
  • To know the Primary keys.
  • None of the above
View Answer
  • Using BIDS.
  • Using SSMS.
  • Using XMLA.
  • All of the above
View Answer
  • SQL Server Analysis Services
  • SQL Analysis Services
  • SQT Server Analysis Services
  • All of the above
View Answer
  • OFAPS/offline analytical processing
  • OLAPS/online analytical processing
  • OFAPS/offline analysis processing
  • All of the above
View Answer
  • Online analytical processing
  • Offline analytical processing
  • Online analytical paper
  • None of the above
View Answer
  • A language created to allow the users to work with Multi-Dimensional data in Microsoft SQL Server Analysis Services.
  • Multi-Dimensional expression (MDX) is a database.
  • Multi-Dimensional expression (MDX) is a sql.
  • All of the above
View Answer
  • Extract Translation Loading.
  • Extract Transformation Loading
  • Both a and b.
  • None of the above
View Answer
  • For loop based on conditions and for each loop based on objects collections.
  • For loop based on objects collections and for each loop based on objects collections.
  • Both a and b.
  • None of the above
View Answer
  • Input rows count and Output rows count are the same.
  • Input rows count and Output rows count are not the same.
  • Input rows count and Output rows count are different.
  • None of the above
View Answer
  • To create reports.
  • To create reports for users.
  • Business users create reports.
  • None of the above
View Answer
  • A control flow mostly consists of one or more tasks and containers that execute when a package is run.
  • A control flow execute when a package created.
  • program
  • None of the above
View Answer
  • Integration services dataflow engine
  • Integration Services Object Model
  • Runtime and runtime executables
  • All of the above
View Answer