Microsoft
70-432 · Question #93
70-432 Question #93: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #93. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance. Users report that the performance of the application is poor. You use SQL Profiler to capture a workload of the remote instance to a trace table on the remote SQL Server instance. You need to analyze the workload of the remote SQL Server instance on a local SQL Server instance by using the Database Engine Tuning Advisor. What should you do?
Options
- AUse the data collector to recapture the workload.
- BUse SQL Profiler to recapture the workload to a trace file.
- CEnable the XP_MSVER stored procedure on the local server.
- DEnable the XP_MSVER stored procedure on the remote server.
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.