Microsoft
70-432 · Question #27
70-432 Question #27: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance containing a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use?
Options
- AYou should use Dynamic Management Views
- BYou should use SQL Server Resource Governor
- CYou should use SQL Server Profiler
- DYou should use Windows System Monitor
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.