Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
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.
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.
It permanently stores all dimension records
B.
It replaces the transaction log
C.
Sorts, hashes, spills, and temporary results may use it heavily
D.
It creates dashboard bookmarks
Show Answer
Correct Answer: C. Sorts, hashes, spills, and temporary results may use it heavily
Explanation:
Complex joins and aggregations may require work space beyond available memory.
Choose an option to check your answer.
A.
When every query uses unrelated columns
B.
When it materializes a frequently reused deterministic aggregation or join
C.
When source tables change continuously at extreme transaction rates
D.
When the view contains unsupported nondeterministic logic
Show Answer
Correct Answer: B. When it materializes a frequently reused deterministic aggregation or join
Explanation:
An indexed view stores its result physically and can avoid repeated computation.
Choose an option to check your answer.
A.
Reduce storage and I/O, sometimes improving scan performance
B.
Guarantee that source data is correct
C.
Eliminate the need for CPU processing
D.
Convert facts into dimensions
Show Answer
Correct Answer: A. Reduce storage and I/O, sometimes improving scan performance
Explanation:
Compressed pages require fewer physical reads and occupy less storage.
Choose an option to check your answer.
A.
To define DAX measures
B.
To determine report color themes
C.
To replace all indexes
D.
To support storage management, backup strategies, and partition administration
Show Answer
Correct Answer: D. To support storage management, backup strategies, and partition administration
Explanation:
Filegroups map database objects to sets of physical files.
Choose an option to check your answer.
A.
All partitions are merged before each query
B.
The database removes dimension keys
C.
The optimizer reads only partitions relevant to the query predicate
D.
The ETL process deletes old reports
Show Answer
Correct Answer: C. The optimizer reads only partitions relevant to the query predicate
Explanation:
A predicate aligned with the partition key lets irrelevant partitions be skipped.
Choose an option to check your answer.
A.
Splitting a measure into numerator and denominator
B.
Dividing one logical table into separately managed physical segments based on a key
C.
Creating an unrelated copy of every dimension
D.
Moving charts to different dashboard pages
Show Answer
Correct Answer: B. Dividing one logical table into separately managed physical segments based on a key
Explanation:
Partitioning keeps one table interface while organizing data into ranges or groups.
Choose an option to check your answer.
A.
The percentage of each leaf page initially filled with index data
B.
The number of facts assigned to each dimension
C.
The proportion of dashboard space filled with visuals
D.
The percentage of queries allowed to run
Show Answer
Correct Answer: A. The percentage of each leaf page initially filled with index data
Explanation:
Leaving free page space can reduce page splits for future inserts.
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.
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.
Indexes make queries impossible to optimize
B.
Indexes consume storage and slow loads and maintenance
C.
A table can contain only one nonclustered index
D.
Indexes remove historical records
Show Answer
Correct Answer: B. Indexes consume storage and slow loads and maintenance
Explanation:
Each index must be stored and updated when data changes.
