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.
A five-year profitability trend by product line
B.
A forecast of next year’s customer churn
C.
A comparison of strategic KPIs across divisions
D.
A list of today’s unshipped customer orders
Show Answer
Correct Answer: D. A list of today’s unshipped customer orders
Explanation:
Operational reports support immediate day-to-day activities using current detail.
Choose an option to check your answer.
A.
Modify database storage pages directly
B.
Guarantee causal conclusions from every chart
C.
Avoid considering data quality
D.
Interpret, question, and communicate with data appropriately
Show Answer
Correct Answer: D. Interpret, question, and communicate with data appropriately
Explanation:
Data literacy includes understanding measures, context, limitations, and evidence.
Choose an option to check your answer.
A.
Analytical systems cannot measure time
B.
Warehouse queries never use processors
C.
Payment systems use only historical data
D.
Operational transactions have stricter immediate response requirements
Show Answer
Correct Answer: D. Operational transactions have stricter immediate response requirements
Explanation:
Customer-facing transactions require rapid, predictable completion.
Choose an option to check your answer.
A.
A list of random source columns
B.
A commitment to use only one chart type
C.
A replacement for technical testing
D.
A clear understanding of decisions, pain points, measures, and information needs
Show Answer
Correct Answer: D. A clear understanding of decisions, pain points, measures, and information needs
Explanation:
Interviews uncover how people make decisions and where current information fails.
Choose an option to check your answer.
A.
Independent marts are built without shared definitions
B.
Dashboards query operational systems directly with no integration
C.
Each user maintains a private cube
D.
An integrated enterprise warehouse feeds dependent analytical data marts
Show Answer
Correct Answer: D. An integrated enterprise warehouse feeds dependent analytical data marts
Explanation:
The hub provides an enterprise integrated repository, often in normalized form.
Choose an option to check your answer.
A.
Store all data only in spreadsheets
B.
Use OLTP tables for both transactions and dashboards without separation
C.
Keep dimensions in memory but delete facts
D.
Store aggregates multidimensionally while retaining detail in relational storage
Show Answer
Correct Answer: D. Store aggregates multidimensionally while retaining detail in relational storage
Explanation:
HOLAP combines MOLAP speed for summaries with ROLAP scalability for detail.
Choose an option to check your answer.
A.
Retention of detailed historical data
B.
Frequent deletion of old records
C.
High transaction update rates
D.
Exclusive use of current snapshots
Show Answer
Correct Answer: A. Retention of detailed historical data
Explanation:
Long-term history allows measures to be compared across many periods.
Choose an option to check your answer.
A.
They make cross-functional analysis inconsistent and difficult
B.
They automatically improve enterprise data quality
C.
They guarantee common definitions across departments
D.
They remove the need for data reconciliation
Show Answer
Correct Answer: A. They make cross-functional analysis inconsistent and difficult
Explanation:
Silos store related data under different structures and definitions.
Choose an option to check your answer.
A.
Governed enterprise metrics are embedded in repeatable decision processes
B.
Each department maintains unrelated spreadsheet definitions
C.
Reports are created without owners or documentation
D.
Data quality problems are handled only after executive complaints
Show Answer
Correct Answer: A. Governed enterprise metrics are embedded in repeatable decision processes
Explanation:
Mature BI combines governance, trusted data, adoption, and measurable business use.
Choose an option to check your answer.
A.
It integrates multiple sources and retains extensive history
B.
It stores no indexes
C.
It deletes every duplicate business key
D.
It contains only one day of data
Show Answer
Correct Answer: A. It integrates multiple sources and retains extensive history
Explanation:
Warehouses accumulate records across systems and over long time periods.
Choose an option to check your answer.
A.
It defines exactly what one fact row represents
B.
It determines the dashboard color palette
C.
It eliminates all dimension keys
D.
It specifies the database backup format
Show Answer
Correct Answer: A. It defines exactly what one fact row represents
Explanation:
Measures must be valid at the row’s declared level of detail.
Choose an option to check your answer.
A.
Conflicting dimensions, measures, and duplicated integration work
B.
Guaranteed enterprise consistency
C.
Elimination of reconciliation problems
D.
Automatic creation of a semantic layer
Show Answer
Correct Answer: A. Conflicting dimensions, measures, and duplicated integration work
Explanation:
Independent marts often encode different definitions and keys.
