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.
Distribute processing or storage across additional servers
B.
Install more memory in the existing server
C.
Replace the existing CPU with a faster one
D.
Increase the disk capacity of the same machine
Show Answer
Correct Answer: A. Distribute processing or storage across additional servers
Explanation:
Scaling out adds nodes and distributes workload across them.
Choose an option to check your answer.
A.
A primary key that joins every warehouse table
B.
A measurable value used to assess progress toward a business objective
C.
A script that loads data into a staging table
D.
A compression ratio for an index
Show Answer
Correct Answer: B. A measurable value used to assess progress toward a business objective
Explanation:
A KPI links a quantifiable measure to an organizational objective.
Choose an option to check your answer.
A.
To replace the database transaction log
B.
To present important measures in a concise, monitorable visual form
C.
To define every source-system table
D.
To store raw files for long-term archival
Show Answer
Correct Answer: B. To present important measures in a concise, monitorable visual form
Explanation:
Dashboards highlight current status, trends, and exceptions in key measures.
Choose an option to check your answer.
A.
Store only summarized historical measures
B.
Process routine business transactions accurately and efficiently
C.
Support multidimensional trend analysis
D.
Create executive dashboards from cubes
Show Answer
Correct Answer: B. Process routine business transactions accurately and efficiently
Explanation:
OLTP systems record day-to-day events such as orders and payments.
Choose an option to check your answer.
A.
A cashier recording a sale
B.
An analyst exploring patterns and trends
C.
A customer changing a password
D.
A warehouse scanner confirming one item
Show Answer
Correct Answer: B. An analyst exploring patterns and trends
Explanation:
OLAP is built for analysts, managers, and decision-makers.
Choose an option to check your answer.
A.
Which users may change dashboard colors
B.
How source fields and rules populate warehouse columns
C.
How many CPU cores a report consumes
D.
Which business targets each KPI should meet
Show Answer
Correct Answer: B. How source fields and rules populate warehouse columns
Explanation:
Mappings document origins, transformations, lookups, defaults, and target fields.
Choose an option to check your answer.
A.
A single spreadsheet stored on one laptop
B.
A coordinated analytical environment that integrates access across multiple existing repositories
C.
A warehouse with no metadata
D.
An OLTP system with extra indexes
Show Answer
Correct Answer: B. A coordinated analytical environment that integrates access across multiple existing repositories
Explanation:
Federation presents a unified analytical view while data remains in multiple systems.
Choose an option to check your answer.
A.
Guarantee that every analytical conclusion is correct
B.
Minimize service interruption when components fail
C.
Eliminate the need for data-quality rules
D.
Make all users database administrators
Show Answer
Correct Answer: B. Minimize service interruption when components fail
Explanation:
High availability uses redundancy and failover to reduce downtime.
Choose an option to check your answer.
A.
To choose random tables from each source system
B.
To ensure every report uses the same chart type
C.
To identify the decisions, processes, measures, and users the solution must support
D.
To avoid communicating with stakeholders
Show Answer
Correct Answer: C. To identify the decisions, processes, measures, and users the solution must support
Explanation:
Requirements connect warehouse design to real business questions and outcomes.
Choose an option to check your answer.
A.
It can display only one measure at a time
B.
It contains no historical values
C.
It explicitly tracks measures against strategic objectives and targets
D.
It is used only by database developers
Show Answer
Correct Answer: C. It explicitly tracks measures against strategic objectives and targets
Explanation:
Scorecards connect KPIs to goals, targets, and strategic performance.
Choose an option to check your answer.
A.
Capture each point-of-sale transaction
B.
Maintain source-code versions
C.
Enable multidimensional analysis of aggregated and historical data
D.
Manage network authentication logs
Show Answer
Correct Answer: C. Enable multidimensional analysis of aggregated and historical data
Explanation:
OLAP supports interactive analysis across dimensions and levels of detail.
Choose an option to check your answer.
A.
Preserve every dashboard filter selection
B.
Keep precomputed cube aggregations forever
C.
Prevent loss of committed transactions
D.
Retain temporary visualization tooltips
Show Answer
Correct Answer: C. Prevent loss of committed transactions
Explanation:
Committed operational transactions represent legally and financially important events.
