70-466 · Question #119
You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube. A user reports that a Multidimensional Expressions (MDX) query is very slow. You need to identify the MDX…
The correct answer is B. Query Begin. The Query Begin event class in SQL Server Profiler captures the MDX query statement text when a query is submitted to SSAS, making it the correct event for identifying slow MDX queries.
Question
Options
- AProgress Report Begin
- BQuery Begin
- CExecute MDX Script Begin
- DCalculate Non Empty Begin
- EGet Data From Aggregation
- FQuery Subcube
How the community answered
(22 responses)- B91% (20)
- C5% (1)
- F5% (1)
Why each option
The Query Begin event class in SQL Server Profiler captures the MDX query statement text when a query is submitted to SSAS, making it the correct event for identifying slow MDX queries.
Progress Report Begin tracks the progress of SSAS processing operations (dimension or cube processing), not client MDX query execution.
The Query Begin event class fires when SSAS begins processing a client-submitted MDX query and includes the query text in the TextData column of the trace, allowing direct identification of the slow statement. It corresponds to the full end-to-end query lifecycle as initiated by the user or application, making it the appropriate event for query-level performance troubleshooting.
Execute MDX Script Begin captures the execution of MDX calculation scripts defined in the cube, not ad-hoc MDX queries submitted by users.
Calculate Non Empty Begin is a sub-event within query execution that tracks the non-empty cell calculation phase, not the overall query statement.
Get Data From Aggregation is a sub-event indicating that data is being retrieved from a pre-built aggregation, not the MDX query statement itself.
Query Subcube tracks internal subcube data requests generated during query resolution, not the original MDX query statement submitted by the user.
Concept tested: SQL Server Profiler event class for SSAS MDX query tracing
Source: https://learn.microsoft.com/en-us/analysis-services/trace-events/query-events-data-columns
Topics
Community Discussion
No community discussion yet for this question.