70-467 Question #96: Real Exam Question with Answer & Explanation

The correct answer is A: Performance Monitor configured with the MSAS11:Storage Engine Query counter. The MSAS11:Storage Engine Query counter in Performance Monitor tracks the rate of storage engine queries against an Analysis Services instance, directly measuring query load for monitoring purposes.

Question

You need to select and configure a tool for the monitoring solution. What should you choose?

Options

APerformance Monitor configured with the MSAS11:Storage Engine Query counter
BPerformance Monitor configured with the MSAS11:Processing counter
CSQL Server Profiler configured with the Query Processing: Query Subcube event
DSQL Server Profiler configured with the Queries Events: Query Begin event

Explanation

The MSAS11:Storage Engine Query counter in Performance Monitor tracks the rate of storage engine queries against an Analysis Services instance, directly measuring query load for monitoring purposes.

Common mistakes.

B. The MSAS11:Processing counter tracks dimension and partition processing operations rather than query execution, so it does not reflect end-user query activity on the server.
C. SQL Server Profiler with the Query Processing: Query Subcube event captures internal subcube requests during query execution, which is useful for deep query diagnostics but is too granular and resource-intensive for an ongoing monitoring solution.
D. SQL Server Profiler with the Queries Events: Query Begin event captures the start of MDX queries and is useful for troubleshooting individual queries, but Profiler introduces significant overhead and is not designed for sustained production monitoring.

Concept tested. Analysis Services performance monitoring with Performance Monitor counters

Reference. https://learn.microsoft.com/en-us/analysis-services/instances/use-sql-server-profiler-to-monitor-analysis-services

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice