6. You have just upgraded your databases from a SQL Server 2005 default
instance to a SQL Server 2008 named instance called Phobos on a server
named MARS. The application that uses the SQL Server sits on its own server,
and you’ve just found out that you can’t change the connection string in the
application to point to the new instance. How can you fix it?
A. Add a CNAME record on your DNS server for MARS that points to
MARS\Phobos
B. Install SQL Server Client Tools on the application server and create a SQL
Server Alias called MARS that points to MARS\Phobos
C. Install SQL Server Client Tools on the application server and create a SQL
Server Alias called MARS\Default that points to MARS\Phobos
D. Add a PTR record on your DNS server for MARS that points to MARS\
Phobos
Correct Answer & Explanation: B. Connection requests from the application
to MARS will be redirected to MARS\Phobos without you having to change
the connection string.
Incorrect Answers & Explanations: A, C, D. Answer A is incorrect because
DNS resolves IP addresses, and you still need to connect to same server
(MARS). DNS has no awareness of instances. Answer C is incorrect because
you connect to a default instance using the servername, not servername\
Default. Answer D is incorrect because DNS resolves IP addresses, and
you still need to connect to same server (MARS). DNS has no awareness
of instances.
Bạn đang xem 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P143 PPTX