Question 330
An analyst tunes query speed without measuring changes before and after. What basic practice is missing?
Explanation
Correct Answer
Establish a performance baseline and retest with comparable representative workloads. Repeatable benchmarks are needed to substantiate optimization gains.
Incorrect Answers
Rendering too much granular content can be expensive and hard to use. Its application is “millions of detailed rows and overwhelms report responsiveness”, not the need “query speed without measuring changes before and after”.
Custom visuals can introduce extra rendering and maintenance cost. It serves “visual scripts even though native visuals meet requirements”, not “query speed without measuring changes before and after”.
Calculated columns add storage that may not be needed for dynamic aggregates. The present requirement is “query speed without measuring changes before and after”; “uses multiple high-cardinality calculated columns exclusively for measures” is a distinct situation.