• Admin
  • 19th Jan, 2021

MSBI MCQ Online Test

Following are mostly asked Msbi MCQ test that are designed for professionals like you to crack you interviews. You can take this Msbi online test before appearing to you real interview. This Msbi quiz there are around 30+ multiple choice questions on Msbi with four options.

1) Define Row Number function?

  • A. Generate sequence number based on order by column
  • B. Generate number
  • C. Generate sequence number
  • D. All of the above

2) What is Normalization?

  • A. Join the tables
  • B. Split the table to reduce duplicates,it has five types
  • C. Move the data into tables
  • D. All of the above

3) What are different types of joins?

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

4) What are the advantages of using stored procedure?

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

5) BCP meaning is:

  • A. Business continuity program
  • B. Both A and C
  • C. Bulk copy program
  • D. None
Download Free : MSBI MCQ PDF

6) Define Index?

  • A. It is foreign key
  • B. It is primary key
  • C. Predefined pointers to data page
  • D. None of the above

7) What command do we use to rename db, table, and column?

  • A. Invoke command
  • B. Rename
  • C. Commit
  • D. None of the above

8) Define having clause?

  • A. It is equal to from clause
  • B. It is primary clause
  • C. It is equal to where clause
  • D. It is similar to where but must use group by clause

9) Basic functions system databases is:

  • A. To create stored procedure
  • B. To maintain metadata information
  • C. None
  • D. To create functions

10) Explain ETL process?

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

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

  • A. Both b and c
  • B. For loop based on conditions
  • C. for each loop based on objects collections
  • D. None

12) What does a control flow do?

  • A. To control data flows
  • B. To control lookup
  • C. To control workflow
  • D. To control events

13) What is event handlers?

  • A. To handle data validations
  • B. To handle events
  • C. To handle errors
  • D. All of the above

14) SSIS 2008 configuration types?

  • A. Four
  • B. Five
  • C. Three
  • D. Tow

15) Define Lookup transformation?

  • A. Used as master table
  • B. Used as fact table
  • C. Used as reference table
  • D. both b and c

16) Define synchronous transformations?

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

17) How to rename file using SSIS tasks?

  • A. Using Data flow
  • B. Using File system task
  • C. Using lookup
  • D. None of these

18) Data auditing means?

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

19) How many container tasks available in SSIS?

  • A. Two
  • B. Four
  • C. Three
  • D. One

20) Define role play dimensions?

  • A. Shared across cubes
  • B. One dimension used in different cubes
  • C. One dimension used multiple times in the cube
  • D. None of these

21) Define dimension usage in SSAS Cube?

  • A. To build business logic
  • B. To maintain cube data size
  • C. To know the relationships between dimensions and fact
  • D. None of these

22) MDX stands for?

  • A. Memory, dimension, expressions
  • B. Multi, dimension, expressions
  • C. Memory, distribution, extensions
  • D. None of these

23) DSV stand for:

  • A. It has relationships and metadata
  • B. Data source View
  • C. It is view
  • D. All of the above

24) How many types of actions available in the Cube?

  • A. Three
  • B. Four
  • C. Two
  • D. Five

25) In which scenario, you would like to go for materializing dimension?

  • A. decrease memory size
  • B. Increase speed
  • C. Both a and b
  • D. None of the above

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

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

27) Describe Reporting Lifecycle?

  • A. Report authoring, Management, Delivery
  • B. Reports and reports models
  • C. Both
  • D. None of these

28) What can SQL Server Reporting Services do?

  • A. To create Reports
  • B. To create tables
  • C. To create files
  • D. All of the above

29) Define reporting process?

  • A. Report data processing
  • B. Report delivery process
  • C. Report rendering process
  • D. All of the these

30) What is the usage of Report Builder?

  • A. To create reports for users
  • B. Business users create reports
  • C. To create reports
  • D. None

31) MSBI stands for ____.

  • A. Microsoft Business Intelligence
  • B. Multi Business Intelligence
  • C. Multiple Business Intelligence
  • D. None of the above

32) MSBI is a powerful software tool developed by ___ to provide the best business intelligence solutions.

  • A. Yahoo
  • B. Google
  • C. Microsoft
  • D. All of the above

33) SSIS architecture involves ___.

  • A. Integration services dataflow engine
  • B. Integration Services Object Model
  • C. Runtime and runtime executables
  • D. All of the above

34) OLAP stands for ____.

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

35) What does mean by data auditing?

  • A. maintaining data load statistics in ETL process.
  • B. knowing the Primary keys.
  • C. knowing the errors.
  • D. None of the above

36) SSIS 2008 configuration types?

  • A. Two
  • B. Four
  • C. Five
  • D. Three

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

  • A. BIDS
  • B. SSMS
  • C. XMLA
  • D. All the above

38) What do you know about stored procedure?

  • A. a pre executable code
  • B. information
  • C. commands
  • D. similar to function

39) Which server provide advanced query language and query processing support for SQL queries over star and snowflake schemas in a read-only environment?

  • A. Relational OLAP
  • B. Multidimensional OLAP
  • C. Hybrid OLAP
  • D. Specialized SQL servers

40) Which OLAP is a combination of both ROLAP and MOLAP?

  • A. Hybrid OLAP
  • B. Specialized SQL servers
  • C. Multidimensional OLAP
  • D. None of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

Spring MCQ
JavaScript MCQ
Magento MCQ
Kubernetes MCQ