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.
The number of distinct values the attribute can contain
B.
The amount of disk space used by the fact table
C.
The number of dashboards in a workspace
D.
The duration of an ETL load
Show Answer
Correct Answer: A. The number of distinct values the attribute can contain
Explanation:
Cardinality indicates how many unique members occur in an attribute.
Choose an option to check your answer.
A.
A predicate identifies a relatively small fraction of table rows
B.
Every value in the indexed column is identical
C.
The index contains no key columns
D.
The query returns the entire table
Show Answer
Correct Answer: A. A predicate identifies a relatively small fraction of table rows
Explanation:
Selective predicates narrow the search to few rows.
Choose an option to check your answer.
A.
When measured query benefits outweigh redundancy and maintenance costs
B.
Whenever a source table has a primary key
C.
To make business definitions less consistent
D.
To prevent all incremental loads
Show Answer
Correct Answer: A. When measured query benefits outweigh redundancy and maintenance costs
Explanation:
Physical design can duplicate or prejoin data to reduce expensive query operations.
Choose an option to check your answer.
A.
Create or use an inferred customer member, then update it later
B.
Discard the fact permanently
C.
Assign the key of an unrelated customer
D.
Wait indefinitely and block the entire warehouse load
Show Answer
Correct Answer: A. Create or use an inferred customer member, then update it later
Explanation:
An inferred member preserves the event while maintaining a valid foreign key.
Choose an option to check your answer.
A.
Fast multidimensional analysis of measures by dimensions and hierarchies
B.
A transactional screen for entering customer orders
C.
A storage location for unprocessed log files
D.
A replacement for all relational databases
Show Answer
Correct Answer: A. Fast multidimensional analysis of measures by dimensions and hierarchies
Explanation:
A cube organizes measures so users can analyze them across multiple business perspectives.
Choose an option to check your answer.
A.
To process, manage, and query separate data segments independently
B.
To eliminate dimensions
C.
To make every measure nonadditive
D.
To prevent historical analysis
Show Answer
Correct Answer: A. To process, manage, and query separate data segments independently
Explanation:
Partitions isolate periods or other segments for incremental processing and maintenance.
Choose an option to check your answer.
A.
Type 2 unlimited historical rows
B.
Type 3 additional previous-value attribute
C.
Type 1 overwrite with no prior value
D.
A periodic snapshot fact
Show Answer
Correct Answer: B. Type 3 additional previous-value attribute
Explanation:
Type 3 stores limited history in additional columns on the same row.
Choose an option to check your answer.
A.
Leave the foreign key invalid
B.
Use a designated “No Promotion” or unknown dimension member
C.
Delete the sales fact
D.
Create a new fact table for nonpromotional sales
Show Answer
Correct Answer: B. Use a designated “No Promotion” or unknown dimension member
Explanation:
Fact foreign keys should remain valid and referentially consistent.
Choose an option to check your answer.
A.
Indexes make queries impossible to optimize
B.
Indexes consume storage and slow loads and maintenance
C.
A table can contain only one nonclustered index
D.
Indexes remove historical records
Show Answer
Correct Answer: B. Indexes consume storage and slow loads and maintenance
Explanation:
Each index must be stored and updated when data changes.
Choose an option to check your answer.
A.
Change the business meaning of a requested measure
B.
Choose an execution strategy with low estimated resource cost while preserving correct results
C.
Return approximate rows without user knowledge
D.
Force every query to use the newest index
Show Answer
Correct Answer: B. Choose an execution strategy with low estimated resource cost while preserving correct results
Explanation:
The optimizer compares valid access, join, and aggregation alternatives.
Choose an option to check your answer.
A.
Silently load them into production facts
B.
Quarantine them with error details for review and controlled reprocessing
C.
Delete them without an audit trail
D.
Change their values randomly until they pass
Show Answer
Correct Answer: B. Quarantine them with error details for review and controlled reprocessing
Explanation:
A reject process protects warehouse quality while preserving evidence.
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.
