12. When you are setting up your clients to connect to a clustered SQL Server
database, to which hostname should they be connecting?
A. The hostname of the node that is actively running the SQL Service
B. The hostname of the node that is not actively running the SQL Service
C. The hostname that was used when setting up the Windows Cluster
D. The hostname that was used when installing SQL Server
The correct answer is D. You will want to have your clients connect to the
hostname that was used when installing SQL Server. Although you can
connect to the hostname that is running the SQL Service, there is no way
to know which host this is. Although you can connect via the hostname that
was set up when configuring the Windows cluster it will work only if both the
Windows Cluster and the SQL Instance are currently on the same node.
As they are in different resource groups it is entirely possible that they will
be on different nodes.
Bạn đang xem 12. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P148 PPT