Microsoft
70-450 · Question #8
70-450 Question #8: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance. You plan to design a monitoring solution for the instance to monitor object usage statistics. The solution must identify a list of first 10 objects for each of the following components: - Most frequently executed stored procedures and functions - Long running Transact-SQL statements You need to implement the monitoring solution to minimize performance effect by using the least amount of administrative effort. What should you do?
Options
- AUse dynamic management views.
- BUse a System Monitor counter log.
- CUse a client-side SQL Server Profiler trace.
- DUse a server-side SQL Server Profiler trace.
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.