Microsoft
70-768 · Question #67
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 C. 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
- AGet Data From Aggregation
- BQuery Subcube
- CQuery Begin
- DProgress Report Begin
- ECalculate Non Empty Begin
- FExecute MDX Script Begin
How the community answered
(23 responses)- A4% (1)
- C78% (18)
- D9% (2)
- F9% (2)
Community Discussion
No community discussion yet for this question.