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.
WHERE
B.
ORDER BY
C.
HAVING
D.
JOIN
Show Answer
Correct Answer: C. HAVING
Explanation:
HAVING applies conditions to grouped results such as SUM or COUNT.
Choose an option to check your answer.
A.
It contains no fact table
B.
All dimensions are stored inside one text column
C.
It eliminates hierarchies from the model
D.
Dimension attributes are normalized into additional related tables
Show Answer
Correct Answer: D. Dimension attributes are normalized into additional related tables
Explanation:
Snowflaking decomposes dimensions into normalized subdimensions.
Choose an option to check your answer.
A.
When it includes every column in the database
B.
When its key is encrypted
C.
When it is rebuilt every hour
D.
When it contains all columns needed to satisfy the query without accessing the base table
Show Answer
Correct Answer: D. When it contains all columns needed to satisfy the query without accessing the base table
Explanation:
A covering index supplies the filter, join, and output columns required by a query.
Choose an option to check your answer.
A.
A table with no rows
B.
A table containing only dimension keys
C.
A cube partition stored in memory
D.
A table without a clustered index
Show Answer
Correct Answer: D. A table without a clustered index
Explanation:
Heap rows are not organized by a clustered key.
Choose an option to check your answer.
A.
A dashboard alignment check
B.
An index fragmentation check
C.
A report subscription check
D.
A domain or business-rule check
Show Answer
Correct Answer: D. A domain or business-rule check
Explanation:
Domain and business rules verify that values fall within valid conditions.
Choose an option to check your answer.
A.
A gradual increase in dashboard users
B.
Movement of rows between date partitions
C.
A change in index page order
D.
An unexpected change in source columns, types, or structure
Show Answer
Correct Answer: D. An unexpected change in source columns, types, or structure
Explanation:
Source structures can evolve without coordinated warehouse changes.
Choose an option to check your answer.
A.
Deletes unused dimension members
B.
Rebuilds all cube partitions
C.
Converts measures into source transactions
D.
Reorients dimensions between rows, columns, or filters without changing the underlying data
Show Answer
Correct Answer: D. Reorients dimensions between rows, columns, or filters without changing the underlying data
Explanation:
Pivot changes the presentation perspective of a multidimensional result.
Choose an option to check your answer.
A.
HAVING cannot contain dates
B.
WHERE automatically creates an index
C.
HAVING changes the fact-table grain
D.
WHERE reduces input rows before aggregation and expresses the intended logic
Show Answer
Correct Answer: D. WHERE reduces input rows before aggregation and expresses the intended logic
Explanation:
Filtering early reduces the data that must be joined and aggregated.
Choose an option to check your answer.
A.
To resolve a many-to-many relationship between facts and dimension members
B.
To replace the staging area
C.
To store database backup files
D.
To create a one-to-one relationship between every table
Show Answer
Correct Answer: A. To resolve a many-to-many relationship between facts and dimension members
Explanation:
A bridge stores associations and sometimes allocation weights for multivalued relationships.
Choose an option to check your answer.
A.
The leading columns determine which search predicates and sort orders can use the index efficiently
B.
SQL Server sorts the key columns alphabetically at runtime
C.
Only the last key column can be filtered
D.
Column order changes the business meaning of stored facts
Show Answer
Correct Answer: A. The leading columns determine which search predicates and sort orders can use the index efficiently
Explanation:
B-tree navigation is most effective from the leftmost key prefix.
Choose an option to check your answer.
A.
To cover query output columns without enlarging the searchable key
B.
To change the table grain
C.
To create foreign-key relationships automatically
D.
To partition the index by dashboard page
Show Answer
Correct Answer: A. To cover query output columns without enlarging the searchable key
Explanation:
Included columns are stored at the leaf level but are not part of key ordering.
Choose an option to check your answer.
A.
Derivation of a new attribute or measure
B.
Source extraction
C.
Index rebuilding
D.
Dashboard filtering
Show Answer
Correct Answer: A. Derivation of a new attribute or measure
Explanation:
A derived field is calculated from one or more source values.
