nerdexam
Microsoft

70-448 · Question #331

You maintain a SQL Server 2008 Analysis Services (SSAS) database. You plan to troubleshoot query performance by using SQL Profiler. You need to identify the queries that take a long time to run…

The correct answer is B. Query Subcube. See the full explanation below for the reasoning.

Question

You maintain a SQL Server 2008 Analysis Services (SSAS) database. You plan to troubleshoot query performance by using SQL Profiler. You need to identify the queries that take a long time to run. Which trace event should you use?

Options

  • AQuery Cube End
  • BQuery Subcube
  • CMDX Script End
  • DGet Data from Cache

How the community answered

(30 responses)
  • A
    10% (3)
  • B
    80% (24)
  • C
    3% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice