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)- A2% (1)
- B77% (33)
- C5% (2)
- D5% (2)
- E12% (5)
Community Discussion
No community discussion yet for this question.