Microsoft
70-460 · Question #13
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. See the full explanation below for the reasoning.
Question
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 query statement in a trace by using SQL Server Profiler. Which event class should you use?
Options
- AProgress Report Begin
- BQuery Begin
- CExecute MDX Script Begin
- DCalculate Non Empty Begin
- EGet Data From Aggregation
- FQuery Subcube
How the community answered
(23 responses)- A17% (4)
- B74% (17)
- D4% (1)
- E4% (1)
Community Discussion
No community discussion yet for this question.