You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance with failover clustering. You have received instructions from management to encrypt the
connections in the failover cluster.
How can this be accomplished? Select all that apply.
A.
By obtaining an appropriate encryption certificate.
B.
By obtaining an appropriate encryption license.
C.
By installing the encryption certificate on all computers in the domain.
D.
By installing the encryption certificate on all servers in the domain.
E.
By installing the encryption certificate on all SQL servers in the domain.
F.
By installing the encryption certificate on all nodes in the failover cluster.
G.
By installing the encryption license in the local group.
H.
By installing the encryption license in the no-cluster group.
I.
By installing the encryption license in the cluster group.
J.
By installing the encryption certificate in a shared folder on the SQL Server.
K.
By Installing the encryption certificate on the cluster quorum drive.
Explanation:
If you deploy SQL Server with a failover cluster, you must install the server certificate with the
FQDN of the virtual server on all nodes in the failover cluster.