nerdexam
Microsoft

70-448 · Question #166

70-448 Question #166: Real Exam Question with Answer & Explanation

Sign in or unlock 70-448 to reveal the answer and full explanation for question #166. The question stem and answer options stay visible for context.

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

Unlock 70-448 to see the answer

You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-448 Practice