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.
Users should probably like the dashboard
B.
The system should contain many tables
C.
Daily sales totals must reconcile to approved source controls within the stated tolerance
D.
Queries should be fast enough for everyone
Show Answer
Correct Answer: C. Daily sales totals must reconcile to approved source controls within the stated tolerance
Explanation:
Good acceptance criteria are measurable, testable, and tied to business requirements.
Choose an option to check your answer.
A.
A warehouse used only in virtual-reality applications
B.
A fact table without dimension keys
C.
An analytical view that accesses integrated data without fully storing all of it in one physical warehouse
D.
A backup copy of an OLTP database
Show Answer
Correct Answer: C. An analytical view that accesses integrated data without fully storing all of it in one physical warehouse
Explanation:
Virtualization combines data through views or semantic access rather than full physical consolidation.
Choose an option to check your answer.
A.
Only textual descriptions of customers
B.
Database user passwords
C.
Business measurements and foreign keys at a declared grain
D.
ETL package source code
Show Answer
Correct Answer: C. Business measurements and foreign keys at a declared grain
Explanation:
Fact tables record measurable business events or states.
Choose an option to check your answer.
A.
A centralized repository of integrated, historical data designed for analysis
B.
A temporary cache used only during transactions
C.
A database that stores only current operational records
D.
A spreadsheet containing departmental budgets
Show Answer
Correct Answer: A. A centralized repository of integrated, historical data designed for analysis
Explanation:
A data warehouse consolidates data from multiple sources for analytical use.
Choose an option to check your answer.
A.
Replacing all operational databases with spreadsheets
B.
Transforming organizational data into useful information for decisions
C.
Writing source code for transaction-processing systems
D.
Encrypting every record before it enters a database
Show Answer
Correct Answer: B. Transforming organizational data into useful information for decisions
Explanation:
BI combines processes and tools that turn data into actionable insight.
Choose an option to check your answer.
A.
Nonvolatile data
B.
Real-time transaction locking
C.
Integrated data
D.
Physical data compression
Show Answer
Correct Answer: C. Integrated data
Explanation:
Integration resolves naming, coding, and structural differences among sources.
Choose an option to check your answer.
A.
Write optimization
B.
Volatile storage
C.
Process isolation
D.
Subject orientation
Show Answer
Correct Answer: D. Subject orientation
Explanation:
A subject-oriented warehouse is structured around major business subjects.
Choose an option to check your answer.
A.
To support analysis of changes and trends over time
B.
To prevent users from viewing older records
C.
To make every transaction update immediately
D.
To remove the need for dimension tables
Show Answer
Correct Answer: A. To support analysis of changes and trends over time
Explanation:
Time-variant data lets analysts compare performance across periods.
Choose an option to check your answer.
A.
Users update warehouse rows during every sales transaction
B.
Loaded records are mainly read and appended rather than continually overwritten
C.
Old data is deleted whenever new data arrives
D.
All queries must run inside write transactions
Show Answer
Correct Answer: B. Loaded records are mainly read and appended rather than continually overwritten
Explanation:
Nonvolatile means warehouse data is stable after it is loaded.
Choose an option to check your answer.
A.
It guarantees that every source uses the same software
B.
It processes point-of-sale transactions faster than OLTP
C.
It provides an enterprise-wide integrated analytical platform
D.
It eliminates the need for business definitions
Show Answer
Correct Answer: C. It provides an enterprise-wide integrated analytical platform
Explanation:
A warehouse brings data from multiple business areas into a common environment.
Choose an option to check your answer.
A.
Only one employee is allowed to create reports
B.
The warehouse contains exactly one table
C.
All business measures must have identical values
D.
Users rely on governed, consistent definitions and reconciled data
Show Answer
Correct Answer: D. Users rely on governed, consistent definitions and reconciled data
Explanation:
A governed BI platform standardizes data and metric definitions.
Choose an option to check your answer.
A.
A subject- or department-focused subset of analytical data
B.
A log of uncommitted database transactions
C.
A utility that repairs corrupted indexes
D.
A tool used only to create charts
Show Answer
Correct Answer: A. A subject- or department-focused subset of analytical data
Explanation:
A data mart serves a focused business area such as finance or marketing.
