Posted by: Pdfprep
Post Date: October 30, 2020
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?
A . Get Data From Aggregation
B . Query Subcube
C . Query Begin
D . Progress Report Begin
E . Calculate Non Empty Begin
F . Execute MDX Script Begin
Answer: C
Leave a Reply