DP-500 · Question #33
You discover a poorly performing measure in a Power BI data model. You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine. What should you…
The correct answer is D. DAX Studio. To analyze a poorly performing DAX measure's query plan and execution time split between the storage and formula engines, DAX Studio is the appropriate tool.
Question
Options
- ATabular Editor
- BPerformance analyzer in Power BI Desktop
- CVertipaq Analyzer
- DDAX Studio
How the community answered
(58 responses)- A17% (10)
- B9% (5)
- C3% (2)
- D71% (41)
Why each option
To analyze a poorly performing DAX measure's query plan and execution time split between the storage and formula engines, DAX Studio is the appropriate tool.
Tabular Editor is for model authoring and management, not for run-time query performance analysis.
Performance analyzer in Power BI Desktop gives high-level visual timings but lacks the detailed query plan and formula/storage engine breakdown provided by DAX Studio.
VertiPaq Analyzer focuses on data model memory usage and compression, not the execution plan or engine timings of specific DAX queries.
DAX Studio is the specialized tool for in-depth DAX query analysis. Its 'Server Timings' feature provides a detailed breakdown of how much time a specific DAX query spends in the Formula Engine (processing DAX logic) versus the Storage Engine (retrieving data), while the 'Query Plan' visualizes the execution steps, both critical for identifying performance bottlenecks.
Concept tested: DAX query performance analysis tools
Source: https://dax.studio/features/server-timings/
Topics
Community Discussion
No community discussion yet for this question.