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 guarantee that every prediction will be correct
B.
Removal of all human judgment from management
C.
Faster entry of individual sales transactions
D.
More informed and timely decisions based on trusted evidence
Show Answer
Correct Answer: D. More informed and timely decisions based on trusted evidence
Explanation:
BI improves access to consistent information and analytical insight.
Choose an option to check your answer.
A.
Fixed batch processing
B.
Transaction rollback
C.
Schema replication
D.
Ad hoc analysis
Show Answer
Correct Answer: D. Ad hoc analysis
Explanation:
Ad hoc analysis supports questions not predefined in standard reports.
Choose an option to check your answer.
A.
To maximize repeated descriptive values
B.
To eliminate all table joins
C.
To precompute every possible aggregate
D.
To reduce redundancy and update anomalies during transactions
Show Answer
Correct Answer: D. To reduce redundancy and update anomalies during transactions
Explanation:
Normalization keeps transactional updates consistent and avoids unnecessary duplication.
Choose an option to check your answer.
A.
A dashboard comparing branch profitability over ten years
B.
A cube used to slice revenue by product and region
C.
A report forecasting next year’s deposits
D.
A banking system posting deposits and withdrawals
Show Answer
Correct Answer: D. A banking system posting deposits and withdrawals
Explanation:
Posting deposits and withdrawals is routine transaction processing.
Choose an option to check your answer.
A.
To avoid documenting data definitions
B.
To replace all production testing
C.
To load ungoverned data permanently
D.
To validate requirements and usability with limited investment
Show Answer
Correct Answer: D. To validate requirements and usability with limited investment
Explanation:
A prototype makes concepts tangible and exposes misunderstandings early.
Choose an option to check your answer.
A.
Create only presentation slides
B.
Manage Tableau workbook colors
C.
Replace all ETL transformation logic with email
D.
Store and query relational warehouse, staging, and metadata tables
Show Answer
Correct Answer: D. Store and query relational warehouse, staging, and metadata tables
Explanation:
The Database Engine provides relational storage, indexing, security, and query processing.
Choose an option to check your answer.
A.
Store only transaction amounts
B.
Record database lock activity
C.
Hold temporary ETL error messages
D.
Provide descriptive context used to filter, group, and label facts
Show Answer
Correct Answer: D. Provide descriptive context used to filter, group, and label facts
Explanation:
Dimensions describe the who, what, where, when, and how of facts.
Choose an option to check your answer.
A.
Descriptive analytics
B.
Prescriptive analytics
C.
Reinforcement learning
D.
Transaction processing
Show Answer
Correct Answer: A. Descriptive analytics
Explanation:
Descriptive analytics explains what has already happened using summaries and reports.
Choose an option to check your answer.
A.
Drill-through
B.
Roll-up
C.
Data masking
D.
Index compression
Show Answer
Correct Answer: A. Drill-through
Explanation:
Drill-through moves from an aggregate result to detailed source or fact records.
Choose an option to check your answer.
A.
To simplify analytical queries and reduce joins
B.
To increase update anomalies intentionally
C.
To enforce row-by-row transaction locking
D.
To prevent users from aggregating measures
Show Answer
Correct Answer: A. To simplify analytical queries and reduce joins
Explanation:
Denormalized dimensions make business attributes easier to query.
Choose an option to check your answer.
A.
An executive analyzes profit by year, product category, and country
B.
A clerk creates a new purchase order
C.
A terminal records an ATM withdrawal
D.
A website updates one customer address
Show Answer
Correct Answer: A. An executive analyzes profit by year, product category, and country
Explanation:
The executive is exploring measures across multiple analytical dimensions.
Choose an option to check your answer.
A.
User adoption, communication, training, and changes to decision processes
B.
Index page splits and disk fragmentation
C.
Only database backup procedures
D.
Only the purchase of visualization licenses
Show Answer
Correct Answer: A. User adoption, communication, training, and changes to decision processes
Explanation:
BI changes how people access information and make decisions.
