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.
Guarantee source values are accurate
B.
Reuse recently accessed data or results to reduce repeated computation and I/O
C.
Permanently replace warehouse storage
D.
Convert OLTP transactions into dimensions
Show Answer
Correct Answer: B. Reuse recently accessed data or results to reduce repeated computation and I/O
Explanation:
Caching speeds repeated or related analytical queries.
Choose an option to check your answer.
A.
They make all descriptive attributes unique
B.
They eliminate the need for ETL lookups
C.
They provide stable warehouse identifiers independent of changing source keys
D.
They are always meaningful to business users
Show Answer
Correct Answer: C. They provide stable warehouse identifiers independent of changing source keys
Explanation:
Surrogate keys insulate the warehouse from source-key reuse and change.
Choose an option to check your answer.
A.
A periodic snapshot
B.
A conformed fact
C.
A late-arriving dimension
D.
A clustered index scan
Show Answer
Correct Answer: C. A late-arriving dimension
Explanation:
The fact references a dimension member not yet available in the warehouse.
Choose an option to check your answer.
A.
Automatic correction of incorrect facts
B.
Loss of dimension relationships
C.
Additional page reads and less efficient range scans
D.
Conversion of the table into a cube
Show Answer
Correct Answer: C. Additional page reads and less efficient range scans
Explanation:
Fragmentation disrupts page order and may reduce page density.
Choose an option to check your answer.
A.
Evaluate, Test, and Log
B.
Encrypt, Transfer, and Lock
C.
Extract, Transform, and Load
D.
Explore, Tag, and Link
Show Answer
Correct Answer: C. Extract, Transform, and Load
Explanation:
ETL moves data from source systems into an analytical target.
Choose an option to check your answer.
A.
Dashboard background color and font size
B.
User’s current browser window dimensions
C.
Load batch identifier, source system, and load timestamp
D.
Number of report pages printed
Show Answer
Correct Answer: C. Load batch identifier, source system, and load timestamp
Explanation:
Audit attributes show when and how a row entered the warehouse.
Choose an option to check your answer.
A.
It stores only calculated numeric values
B.
It controls operating-system memory
C.
It provides descriptive axes and attributes for slicing and grouping measures
D.
It records ETL package errors
Show Answer
Correct Answer: C. It provides descriptive axes and attributes for slicing and grouping measures
Explanation:
Dimensions define analytical context such as Time, Product, Customer, and Geography.
Choose an option to check your answer.
A.
A list of unrelated SQL tables
B.
A complete ETL package
C.
A coordinate formed by one member from one or more dimensions
D.
A physical disk allocation unit
Show Answer
Correct Answer: C. A coordinate formed by one member from one or more dimensions
Explanation:
A tuple identifies a cube cell or slice coordinate across dimensions.
Choose an option to check your answer.
A.
A generated integer with no business meaning
B.
A measure calculated in a cube
C.
A partition number assigned by the database
D.
A business identifier supplied by a source system, such as CustomerCode
Show Answer
Correct Answer: D. A business identifier supplied by a source system, such as CustomerCode
Explanation:
Natural keys identify entities in operational business contexts.
Choose an option to check your answer.
A.
A role-playing dimension
B.
A Type 1 change
C.
A natural hierarchy
D.
A late-arriving fact
Show Answer
Correct Answer: D. A late-arriving fact
Explanation:
A late-arriving fact belongs to an earlier business period but is loaded later.
Choose an option to check your answer.
A.
They store the complete query result permanently
B.
They replace dimension tables
C.
They prevent users from filtering reports
D.
They help estimate row counts and choose efficient execution plans
Show Answer
Correct Answer: D. They help estimate row counts and choose efficient execution plans
Explanation:
The optimizer relies on data-distribution estimates to compare plan alternatives.
Choose an option to check your answer.
A.
When only one new row must be loaded
B.
When source systems expose reliable change tracking
C.
When the load window is too small for all rows
D.
When the complete source dataset is small enough or changes cannot be identified reliably
Show Answer
Correct Answer: D. When the complete source dataset is small enough or changes cannot be identified reliably
Explanation:
A full extraction retrieves all relevant source records each cycle.
