Microsoft
70-448 · Question #336
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…
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
How the community answered
(57 responses)- A5% (3)
- B2% (1)
- C81% (46)
- D12% (7)
Community Discussion
No community discussion yet for this question.