MSBI MCQs
MSBI MCQs
These MSBI multiple-choice questions and their answers will help you strengthen your grip on the subject of MSBI. You can prepare for an upcoming exam or job interview with these 20 MSBI MCQs.
So scroll down and start answering.
1: 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.
2: Define Row Number function?
A. To generate sequence number.
B. To generate sequence number based on order by column.
C. To generate number.
D. None.
3: What is Normalization? Types of normalization?
A. Join the tables
B. Move the data into tables.
C. Split the table to reduce duplicates and it has five types.
D. None
4: What are different types of joins?
A. Inner, outer, self join.
B. Equi join and cross join.
C. Right outer join.
D. All above.
5: What are the advantages of using stored procedure?
A. Pre executable program.
B. We can get the data.
C. Security.
D. It is similar to function.
6: What is BCP?
A. Bulk copy program.
B. Business continuity program.
C. A and B.
D. None.
7: Define Index?
A. Predefined pointers to data page.
B. It is primary key.
C. It is foreign key.
D. None.
8: What command do we use to rename db, table, and column?
A. Invoke command
B. Commit
C. Rename
D. None.
9: Define having clause?
A. It is similar to where but must use group by clause.
B. It is equal to where clause.
C. None.
D. It is equal to from clause.
10: What are the basic functions system databases?
A. To create functions.
B. To create stored procedure.
C. To maintain metadata information.
D. None.
11: Explain ETL process?
A. Extract, Translation, Loading.
B. Extract, Transformation , Loading
C. Both a and b.
D. None.
12: 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. None.
D. Both a and b.
13: What does a control flow do?
A. To control workflow.
B. To control events.
C. To control data flows.
D. To control lookup.
14: Explain event handlers?
A. To handle data validations.
B. To handle errors.
C. To handle events.
D. None.
15: SSIS 2008 configuration types?
A. Five.
B. Four.
C. Three.
D. One.
16: Define Lookup transformation?
A. Used as reference table.
B. Used as master table.
C. Used as fact table
D. None.
17: Define synchronous transformations?
A. Input rows count and Output rows count are same.
B. Input rows count and Output rows count are not same.
C. None.
D. Input rows count and Output rows count are different.
18: How to rename file using SSIS tasks?
A. Using lookup.
B. Using Data flow.
C. Using File system task.
D. None.
19: 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.
20: How many container tasks available in SSIS?
A. One.
B. Two.
C. Three.
D. Four.
21: Define role play dimensions?
A. One dimension used multiple times in the cube.
B. One dimension used in different cubes.
C. Shared across cubes.
D. None.
22: Define dimension usage in SSAS Cube?
A. To maintain cube data size.
B. To know the relationships between dimensions and fact.
C. To build business logic.
D. None.
23: MDX stands?
A. Memory, Distribution, extensions.
B. Memory, dimension, expressions.
C. Multi, dimension, expressions.
D. None
24: DSV stands?
A. Data source View.
B. It is view.
C. It has relationships and metadata.
D. All above.
25: How many types of actions available in the Cube?
A. One.
B. Two.
C. Three.
D. None.
26: What do you understand by dynamic named set (SSAS 2008)?
A. To create dynamic set of members.
B. To create set of members.
C. None.
D. Both a and b.
27: How many types of dimension are possible in SSAS?
A. Four.
B. Five.
C. Six.
D. Seven.
28: In which scenario, you would like to go for materializing dimension?
A. To increase spee
B. To decrease memory size.
C. Both.
D. None.
29: What are the options to deploy SSAS cube in production?
A. Using BIDS.
B. Using SSMS.
C. Using XMLA.
D. All the above.
List of MSBI MCQs Multiple Cho...
Available in:
MSBI MCQs
