MCQ Collection
Data Warehousing and Business Intelligence MCQs
Practice Data Warehousing and Business Intelligence questions with answers and explanations.
Choose an option to check your answer.
A.
To make it immediately editable by all report users
B.
To serve as the final dimensional model
C.
To eliminate source-to-target mappings
D.
To preserve a controllable copy for validation, reconciliation, and restart
Show Answer
Correct Answer: D. To preserve a controllable copy for validation, reconciliation, and restart
Explanation:
Staging decouples source access from downstream processing.
Choose an option to check your answer.
A.
Dimensions require fact measures to generate names
B.
Facts cannot contain numeric columns until dimensions are compressed
C.
Reports can display only dimension tables
D.
Fact foreign keys must resolve to valid dimension surrogate keys
Show Answer
Correct Answer: D. Fact foreign keys must resolve to valid dimension surrogate keys
Explanation:
Fact loading performs lookups against dimension members.
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.
Which colors appear in every chart
B.
How source applications validate transactions
C.
Which indexes are rebuilt automatically
D.
Which users can access specific models, dimensions, members, and measures
Show Answer
Correct Answer: D. Which users can access specific models, dimensions, members, and measures
Explanation:
Analytical security restricts data and model objects according to user roles.
Choose an option to check your answer.
A.
One row per account at the end of each month
B.
One row for each individual ATM withdrawal
C.
One row repeatedly updated as an order progresses
D.
One row for every customer attribute change
Show Answer
Correct Answer: A. One row per account at the end of each month
Explanation:
Periodic snapshots capture the state of a process at regular intervals.
Choose an option to check your answer.
A.
The measurable business process being analyzed
B.
The alphabetical order of source tables
C.
The preferred dashboard color
D.
The number of developers on the project
Show Answer
Correct Answer: A. The measurable business process being analyzed
Explanation:
Dimensional design begins with a business process such as sales, claims, or shipments.
Choose an option to check your answer.
A.
Reduce storage and I/O, sometimes improving scan performance
B.
Guarantee that source data is correct
C.
Eliminate the need for CPU processing
D.
Convert facts into dimensions
Show Answer
Correct Answer: A. Reduce storage and I/O, sometimes improving scan performance
Explanation:
Compressed pages require fewer physical reads and occupy less storage.
Choose an option to check your answer.
A.
Match records using defined identity attributes and retain or merge according to survivorship rules
B.
Round every numeric measure to an integer
C.
Replace all customer names with surrogate keys
D.
Delete every record containing the same city
Show Answer
Correct Answer: A. Match records using defined identity attributes and retain or merge according to survivorship rules
Explanation:
Duplicate resolution requires matching criteria and rules for selecting trusted values.
Choose an option to check your answer.
A.
Resolve dimension keys and insert measures at the declared grain
B.
Store every source description inside the fact
C.
Generate a new dimension row for every measure
D.
Remove all source transaction identifiers
Show Answer
Correct Answer: A. Resolve dimension keys and insert measures at the declared grain
Explanation:
A fact row combines measures with the correct dimensional context.
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.
Present a focused subset of a large model for a particular audience
B.
Provide a security boundary that replaces roles
C.
Store a second physical copy of all cube data
D.
Convert a dimension into a fact table
Show Answer
Correct Answer: A. Present a focused subset of a large model for a particular audience
Explanation:
Perspectives simplify model navigation by exposing relevant tables, measures, and hierarchies.
Choose an option to check your answer.
A.
Individual retail line-item sales
B.
An order pipeline with milestones from placement through delivery
C.
Daily stock market prices
D.
A list of product descriptions
Show Answer
Correct Answer: B. An order pipeline with milestones from placement through delivery
Explanation:
Accumulating snapshots track a process with a predictable beginning and end.
