Microsoft
70-432 · Question #39
70-432 Question #39: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.
Question
You are the administrator of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the remote instance to a trace table by using SQL Profiler. You have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance. Which action should you perform to achieve this goal?
Options
- AYou should recapture the workload by using the data collector.
- BYou should enable the XP_MSVER stored procedure on the local server.
- CYou should enable the XP_MSVER stored procedure on the remote server
- DYou should recapture the workload to a trace file by using SQL Profiler.
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.