DP-500 · Question #34
You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?
The correct answer is B. the query plan. To identify inefficient join operations in a slow-running DAX query using DAX Studio, you should review its query plan.
Question
Options
- Athe query statistics
- Bthe query plan
- Cthe query history
- Dthe server timings
How the community answered
(33 responses)- A12% (4)
- B82% (27)
- C3% (1)
- D3% (1)
Why each option
To identify inefficient join operations in a slow-running DAX query using DAX Studio, you should review its query plan.
Query statistics offer aggregated numbers like CPU time and rows scanned, but they do not detail specific join operations or their efficiency.
The query plan in DAX Studio provides a detailed, step-by-step visualization of how a DAX query is executed by the Analysis Services engine. It explicitly shows Storage Engine operations, including how tables are joined, filtered, and aggregated, which is crucial for identifying inefficient join operations or sub-optimal data access patterns that contribute to slow performance.
Query history simply lists past queries but provides no execution details like join operations.
Server timings break down execution time between the formula and storage engines but do not visually or explicitly detail the join operations within the query's execution path.
Concept tested: DAX Studio query plan analysis
Source: https://dax.studio/features/query-plan/
Topics
Community Discussion
No community discussion yet for this question.