nerdexam
Microsoft

70-448 · Question #166

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…

The correct answer is B. Discover_Commands would be used. See the full explanation below for the reasoning.

Question

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and you are in charge of a SQL Server 2008 Analysis Services (SSRS) instance for the company. According to your plan, a Dynamic Management View (DMV) will be used to troubleshoot query performance. Now you get an order from your manager, according to his requirements, query sessions that execute a query for more than 30,000 ms should be identified. So of the following DMV, which one would be used?

Options

  • ADiscover_Sessions would be used
  • BDiscover_Commands would be used
  • CDiscover_Connections would be used
  • DDiscover_Traces would be used
  • EDiscover_Wizard would be used

How the community answered

(43 responses)
  • A
    2% (1)
  • B
    77% (33)
  • C
    5% (2)
  • D
    5% (2)
  • E
    12% (5)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice