The MSBI 2008 Evaluation Test assesses knowledge in Microsoft Business Intelligence (MSBI), focusing on database concepts like normalization, joins, and stored procedures. It evaluates understanding of data management techniques and tools, essential for professionals in data-driven roles.
A. MOLAP, HOLAP and ROLAP.
B. Process modes.
C. Process options.
D. None.
Rate this question:
A. Extract, Translation, Loading.
B. Extract, Transformation , Loading
C. Both a and b.
D. None.
Rate this question:
A. Used datasets with in dataset.
B. A dataset.
C. None.
D. A table.
Rate this question:
Join the tables
Move the data into tables.
Split the table to reduce duplicates and it has five types.
None
Rate this question:
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.
Rate this question:
A. Using lookup.
B. Using Data flow.
C. Using File system task.
D. None.
Rate this question:
A. To maintain data load statistics in ETL process.
B. To know the errors.
C. To know the Primary keys.
D. None.
Rate this question:
Inner, outer, self join.
Equi join and cross join.
Right outer join.
All above.
Rate this question:
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.
Rate this question:
A. Predefined pointers to data page.
B. It is primary key.
C. It is foreign key.
D. None.
Rate this question:
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.
Rate this question:
A. Used as reference table.
B. Used as master table.
C. Used as fact table
D. None.
Rate this question:
A. Memory, Distribution, extensions.
B. Memory, dimension, expressions.
C. Multi, dimension, expressions.
D. None
Rate this question:
A. Invoke command
B. Commit
C. Rename
D. None.
Rate this question:
A. One.
B. Two.
C. Three.
D. None.
Rate this question:
A. Bulk copy program.
B. Business continuity program.
C. A and B.
D. None.
Rate this question:
A. Pre executable program.
B. We can get the data.
C. Security.
D. It is similar to function.
Rate this question:
A. Tablix,Chart,List
B. Sub Report.
C. Both A and B.
D. None.
Rate this question:
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.
Rate this question:
A. To maintain cube data size.
B. To know the relationships between dimensions and fact.
C. To build business logic.
D. None.
Rate this question:
A. One dimension used multiple times in the cube.
B. One dimension used in different cubes.
C. Shared across cubes.
D. None.
Rate this question:
A. Using BIDS.
B. Using SSMS.
C. Using XMLA.
D. All the above.
Rate this question:
A. To create functions.
B. To create stored procedure.
C. To maintain metadata information.
D. None.
Rate this question:
A. To create dynamic set of members.
B. To create set of members.
C. None.
D. Both a and b.
Rate this question:
A. One.
B. Two.
C. Three.
D. Four.
Rate this question:
A. To handle data validations.
B. To handle errors.
C. To handle events.
D. None.
Rate this question:
To generate sequence number.
To generate sequence number based on order by column.
To generate number.
None.
Rate this question:
A. To create reports.
B. To create reports for users.
C. Business users create reports.
D. None.
Rate this question:
A. To control workflow.
B. To control events.
C. To control data flows.
D. To control lookup.
Rate this question:
A. To increase speed.
B. To decrease memory size.
C. Both.
D. None.
Rate this question:
A. Report data processing.
B. Report rendering process.
C. Report delivery process.
D. All the above.
Rate this question:
A. Model used by Report Builder.
B. Model used by reports.
C. Both.
D. None.
Rate this question:
A. Reports and reports models.
B. Report authoring, Management, Delivery.
C. Both.
D. None.
Rate this question:
A. Three.
B. Four.
C. One.
D. None.
Rate this question:
A. Five.
B. Six.
C. Seven.
D. None.
Rate this question:
A. Five.
B. Four.
C. Three.
D. One.
A. Data source View.
B. It is view.
C. It has relationships and metadata.
D. All above.
Rate this question:
A. Four.
B. Five.
C. Six.
D. Seven.
Rate this question:
A. Four.
B. Five.
C. Two.
D. One.
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Want To Improve Your Business Intelligence? Take This MSBI Quiz
MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining...
Questions:
61 |
Attempts:
5542 |
Last updated:
Mar 21, 2023
|
|
MSBI SSAS Exam Quiz: MCQ!
The MSBI SSAS Exam Quiz assesses knowledge in Microsoft Business Intelligence (MSBI) focusing on SSAS. It covers key concepts like OLAP operations, data models, and performance...
Questions:
165 |
Attempts:
2747 |
Last updated:
Mar 21, 2023
|
Want To Improve Your Business Intelligence? Take This MSBI Quiz
MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining...
Questions:
61 |
Attempts:
5542 |
Last updated:
Mar 21, 2023
|
|
Wait!
Here's an interesting quiz for you.