You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server. The Domain.com network contains a SQL Server 7.0 database server named Certkiller -DB01 that runs on Windows 2000 Server. Service Pack 4 for Windows 2000 Server id installed on Certkiller -DB01.
Domain.com wants to migrate Certkiller -DB01 to SQL Server 2005. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Certkiller -DB01 exceeds the recommended hardware requirements for SQL Server 2005.
What should you do next?
A.
Upgrade Certkiller -DB01 to Windows Sever 2003.
B.
Install Service Pack 4 for SQL Server 7.0 on Certkiller -DB01.
C.
Upgrade SQL Server 7.0 on Certkiller -DB01 to SQL Server 2000.
D.
Run the SQL Server 2005 Setup utility on Certkiller -DB01 and upgrade directly to SQL Server 2005.
Explanation:
You can upgrade from SQL Server 7.0 with Service Pack 4 directly to SQL Server 2005. Thus you need only install Service Pack 4 for SQL Server 7.0.
Incorrect Answers:
A: You do not need to upgrade Certkiller -DB01 to Windows Sever 2003 as SQL Server 2005 can be installed on Windows 2000 Server with Service Pack 4.
C: You do not need to upgrade Certkiller -DB01 to SQL Server 200 as SQL Server 7.0 with Service Pack 4 can be upgraded directly to SQL Server 2005. Besides, you will need to install Service Pack 3 for SQL Server 2000 before you can upgrade it to SQL Server 2005.
D: You need to install Service Pack 4 for SQL Server 7.0 before you can upgrade it directly to SQL Server 2005.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: upgrading SQL Server, upgrading to SQL Server 2005