nerdexam
Microsoft

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.

Configure and maintain an analysis services database

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

(22 responses)
  • B
    91% (20)
  • C
    5% (1)
  • F
    5% (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.

AProgress Report Begin

Progress Report Begin tracks the progress of SSAS processing operations (dimension or cube processing), not client MDX query execution.

BQuery BeginCorrect

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.

CExecute MDX Script Begin

Execute MDX Script Begin captures the execution of MDX calculation scripts defined in the cube, not ad-hoc MDX queries submitted by users.

DCalculate Non Empty Begin

Calculate Non Empty Begin is a sub-event within query execution that tracks the non-empty cell calculation phase, not the overall query statement.

EGet Data From Aggregation

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.

FQuery Subcube

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

#SQL Server Profiler#MDX trace#Query Begin event#SSAS performance monitoring

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice