nerdexam
Microsoft

70-448 · Question #336

70-448 Question #336: Real Exam Question with Answer & Explanation

The correct answer is C. A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support. See the full explanation below for the reasoning.

Question

You are the administrator of a SQL Server 2008 instance. According to the company requirement, you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features. These features will be discontinued. What should you do?

Options

  • AThe SQL Server 2008 Upgrade Advisor should be used.
  • BThe SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes
  • CA SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support
  • DA SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice