Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
A summarized cube value opens the contributing detailed fact records
B.
A hierarchy moves to a parent level
C.
A dimension is removed permanently
D.
A query result is converted into an index
Show Answer
Correct Answer: A. A summarized cube value opens the contributing detailed fact records
Explanation:
Drill-through connects an aggregate cell to its underlying detailed rows.
Choose an option to check your answer.
A.
Deletes unused dimension members
B.
Rebuilds all cube partitions
C.
Converts measures into source transactions
D.
Reorients dimensions between rows, columns, or filters without changing the underlying data
Show Answer
Correct Answer: D. Reorients dimensions between rows, columns, or filters without changing the underlying data
Explanation:
Pivot changes the presentation perspective of a multidimensional result.
Choose an option to check your answer.
A.
Roll-up
B.
Dice
C.
Drill-down
D.
Data masking
Show Answer
Correct Answer: C. Drill-down
Explanation:
Drill-down navigates from summarized levels toward finer detail.
Choose an option to check your answer.
A.
Drill-down
B.
Roll-up
C.
Drill-through
D.
Slice
Show Answer
Correct Answer: B. Roll-up
Explanation:
Roll-up aggregates data to a higher level in a hierarchy.
Choose an option to check your answer.
A.
Dice
B.
Process full
C.
Index seek
D.
Type 1 update
Show Answer
Correct Answer: A. Dice
Explanation:
Dice selects a subcube using sets or ranges from multiple dimensions.
Choose an option to check your answer.
A.
Roll-up
B.
Pivot
C.
Drill-through
D.
Slice
Show Answer
Correct Answer: D. Slice
Explanation:
A slice selects a single value from one dimension and reduces the cube view.
Choose an option to check your answer.
A.
A transaction log and backup file
B.
A source-system primary key only
C.
A target, status, and trend definition
D.
A list of all cube partitions
Show Answer
Correct Answer: C. A target, status, and trend definition
Explanation:
A KPI compares performance with a business goal and indicates direction or condition.
Choose an option to check your answer.
A.
A dimension row inserted by source users
B.
A value defined by an expression rather than stored directly as a base fact
C.
A filegroup containing cube backups
D.
A nonclustered index on a fact table
Show Answer
Correct Answer: B. A value defined by an expression rather than stored directly as a base fact
Explanation:
Calculated members derive reusable analytical results such as margin or year-to-date sales.
Choose an option to check your answer.
A.
They improve aggregation design, navigation, and processing efficiency
B.
They replace all dimension keys with text
C.
They allow users to modify source transactions
D.
They eliminate the need for measures
Show Answer
Correct Answer: A. They improve aggregation design, navigation, and processing efficiency
Explanation:
Attribute relationships tell the engine how dimension members roll up.
Choose an option to check your answer.
A.
Product Color → Customer Age → Invoice Number
B.
Sales Amount → Employee Name → Month
C.
Discount Rate → Database File → Region
D.
Country → State → City
Show Answer
Correct Answer: D. Country → State → City
Explanation:
A natural hierarchy follows real one-to-many relationships between adjacent levels.
Choose an option to check your answer.
A.
It stores only calculated numeric values
B.
It controls operating-system memory
C.
It provides descriptive axes and attributes for slicing and grouping measures
D.
It records ETL package errors
Show Answer
Correct Answer: C. It provides descriptive axes and attributes for slicing and grouping measures
Explanation:
Dimensions define analytical context such as Time, Product, Customer, and Geography.
Choose an option to check your answer.
A.
A list of report users with identical permissions
B.
A collection of related measures usually based on the same fact table
C.
A set of dimension captions
D.
A group of indexes on a staging table
Show Answer
Correct Answer: B. A collection of related measures usually based on the same fact table
Explanation:
A measure group represents one business process or fact source in the cube.
