Which steps should you take?

You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2000 instance that contains a database named TK_DB1. One day you are required to install
a SQL Server 2008 instance. Management wants you to ensure that new third-party SQL
Server 2008 applications can run on both database instances with the minimum amount of
administrative effort while the old SQL Server 2000 applications should be working as before.

Which steps should you take? (Select two.)

You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2000 instance that contains a database named TK_DB1. One day you are required to install
a SQL Server 2008 instance. Management wants you to ensure that new third-party SQL
Server 2008 applications can run on both database instances with the minimum amount of
administrative effort while the old SQL Server 2000 applications should be working as before.

Which steps should you take? (Select two.)

A.
Install SQL Server 2008 as a mixed instance.

B.
Install SQL Server 2008 as a named instance.

C.
Install SQL Server 2008 as a default instance.

D.
Reconfigure the SQL Server 2000 instance application to use the SQL Server 2008 instance.

E.
Reconfigure the SQL Server 2000 server to use the SQL Server 2008.

F.
Configure the new applications to use the new instance.

G.
Configure the new applications to use the default instance.



Leave a Reply 0

Your email address will not be published. Required fields are marked *