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 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server. Certkiller -DB01 contains a database named CK_Sales.
Domain.com intends migrating Certkiller -DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express on a server named Certkiller -SR31. You verify that Certkiller -SR31 exceeds the minimum recommended hardware requirements for SQL Server 2005.
What should you do next?
A.
Upgrade Certkiller -SR31 to Windows Sever 2003 and install Service Pack 1.
B.
Install and run the SQL Server Upgrade Advisor on Certkiller -SR31.
C.
Install SQL Server 2000 on Certkiller -SR31.
D.
Download and install the .NET Framework 2.0.
Explanation:
SQL Server 2005 requires the.NET Framework 2.0. This is automatically installed when SQL Server 2005 is installed but is not automatically installed when SQL Server 2005 Express is installed.
Incorrect Answers:
A: You do not need to upgrade Certkiller -SR31 to Windows Sever 2003 Service Pack 1 as SQL Server 2005 Express can be installed on Windows 2000 Server. You will need to install Service Pack 4 for Windows 2000 Server though.
B: You should run the SQL Server Upgrade Advisor when you want to upgrade an instance of a SQL Server 2000 database to SQL Server 2005.
C: You do not need to install SQL Server 2000 before installing SQL Server 2005 Express.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server Express, before installing