Microsoft
70-448 · Question #118
You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Through utilizing a Dynamic Management View (DMV), you decide to troubleshoot query performance you should make…
The correct answer is C. You should utilize Discover_Commands for DMV. See the full explanation below for the reasoning.
Question
You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. Through utilizing a Dynamic Management View (DMV), you decide to troubleshoot query performance you should make sure that you could improve query sessions times. In order to solve the problem, which is the correct answer?
Options
- AYou should utilize Discover_Log for DMV.
- BYou should utilize Discover_Link for DMV.
- CYou should utilize Discover_Commands for DMV.
- DYou should utilize Discover_request for DMV.
How the community answered
(34 responses)- A12% (4)
- B3% (1)
- C79% (27)
- D6% (2)
Community Discussion
No community discussion yet for this question.