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.
It shows how the value moved and changed from source to report
B.
It guarantees that the number meets its target
C.
It increases the number of chart colors
D.
It prevents all data from being refreshed
Show Answer
Correct Answer: A. It shows how the value moved and changed from source to report
Explanation:
Lineage traces data origins, transformations, and destinations.
Choose an option to check your answer.
A.
Large sequential reads and aggregation of many rows
B.
Constant updates to the same small set of rows
C.
One-row inserts with no analytical queries
D.
Exclusive locks held for long user sessions
Show Answer
Correct Answer: A. Large sequential reads and aggregation of many rows
Explanation:
Analytical queries often scan and aggregate broad sections of fact data.
Choose an option to check your answer.
A.
Facts, dimensions, attributes, relationships, and grain independent of storage details
B.
A list of server rack positions
C.
A finished dashboard theme
D.
A transaction log backup schedule
Show Answer
Correct Answer: A. Facts, dimensions, attributes, relationships, and grain independent of storage details
Explanation:
Logical design expresses how analytical data is organized for business use.
Choose an option to check your answer.
A.
Estimate future storage, processing, memory, and load-window needs
B.
Choose the business definition of profit
C.
Prevent dimension attributes from changing
D.
Ensure every report has a pie chart
Show Answer
Correct Answer: A. Estimate future storage, processing, memory, and load-window needs
Explanation:
Capacity planning anticipates growth in data volume, users, and processing demand.
Choose an option to check your answer.
A.
Query reliability and performance become dependent on remote source availability
B.
The warehouse automatically becomes nonvolatile
C.
Every source is converted into a cube
D.
Historical data is guaranteed to be consistent
Show Answer
Correct Answer: A. Query reliability and performance become dependent on remote source availability
Explanation:
Direct remote access couples analytical performance to operational systems and networks.
Choose an option to check your answer.
A.
A degenerate dimension
B.
A conformed dimension
C.
A junk dimension
D.
An outrigger dimension
Show Answer
Correct Answer: A. A degenerate dimension
Explanation:
A degenerate dimension is a business identifier retained directly in the fact table.
Choose an option to check your answer.
A.
It prevents all users from creating visualizations
B.
It maintains trusted definitions, security, and appropriate data use
C.
It forces every analysis to be performed by database administrators
D.
It removes the need for data ownership
Show Answer
Correct Answer: B. It maintains trusted definitions, security, and appropriate data use
Explanation:
Governance balances analytical flexibility with consistency and control.
Choose an option to check your answer.
A.
A record of one customer purchase yesterday
B.
The governed definition of each customer used across business systems
C.
A temporary ETL error message
D.
A monthly total calculated in a dashboard
Show Answer
Correct Answer: B. The governed definition of each customer used across business systems
Explanation:
Master data represents core business entities shared across processes.
Choose an option to check your answer.
A.
A monthly warehouse snapshot
B.
The operational order-processing system
C.
A historical cube processed last night
D.
An archived dashboard image
Show Answer
Correct Answer: B. The operational order-processing system
Explanation:
Operational systems maintain the latest transaction state.
Choose an option to check your answer.
A.
Defining the meaning of customer profitability
B.
Selecting indexes, partitions, compression, and storage placement
C.
Choosing the project sponsor
D.
Identifying the business process to analyze
Show Answer
Correct Answer: B. Selecting indexes, partitions, compression, and storage placement
Explanation:
Physical design maps the logical model to database structures and hardware resources.
Choose an option to check your answer.
A.
Keyboard, monitor, and printer
B.
Data storage, OLAP or semantic processing, and front-end BI tools
C.
Source code, compiler, and debugger
D.
Users, passwords, and network cables
Show Answer
Correct Answer: B. Data storage, OLAP or semantic processing, and front-end BI tools
Explanation:
The bottom tier stores and integrates data, the middle tier provides analytical services, and the top tier presents BI.
Choose an option to check your answer.
A.
They optimize frequent single-row updates above all else
B.
They compress and scan selected columns efficiently for analytical queries
C.
They remove the need for dimension keys
D.
They can store only text data
Show Answer
Correct Answer: B. They compress and scan selected columns efficiently for analytical queries
Explanation:
Analytical queries often read a few columns across many rows.
