You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Through utilizing SQL Profiler, you decide to troubleshoot search function. You should make sure that it will…

The correct answer is B. You should utilize Query Subcube. The server raises the Query Begin event when it receives an MDX query and the Query End event when it has finished executing the query. The Query Subcube event shows which attributes the server used to satisfy the query. When configuring the trace, you can check the Query…

Maintain a BI Solution

Question

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Through utilizing SQL Profiler, you decide to troubleshoot search function. You should make sure that it will cost a lot of time to query. Which is the correct answer?

Options

AYou should utilize store procedure.
BYou should utilize Query Subcube
CYou should utilize a Dynamic Management View (DMV)
DYou should utilize Transactions Log.

How the community answered

(34 responses)

A
18% (6)
B
74% (25)
C
6% (2)
D
3% (1)

Explanation

The server raises the Query Begin event when it receives an MDX query and the Query End event when it has finished executing the query. The Query Subcube event shows which attributes the server used to satisfy the query. When configuring the trace, you can check the Query Subcube Verbose event to see these attributes in a human-readable format

Topics

#SQL Profiler#Query Subcube#SSAS troubleshooting#query performance

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice