Microsoft
70-450 · Question #117
70-450 Question #117: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #117. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance. The instance contains a large mission-critical database that experiences a high volume of DML activity. Users report that the applications that connect to the database have a slow response time. You need to design a monitoring process that collects the following information: What should you do?
Options
- AUse dynamic management views.
- BUse SQL Server Profiler.
- CUse the System Monitor tool.
- DUse Database Engine Tuning Advisor.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.