You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com consists of two domains named Certkiller -north.com and Certkiller -south.com. There is no trust relationship between Certkiller -north.com and Certkiller -south.com.
Certkiller -north.com consists of a server named Certkiller -DB01 and Certkiller -south.com contains a server named Certkiller -DB02. Certkiller -DB01 and Certkiller -DB02 is both configured to run SQL Server 2005. The SQL Server instance on Certkiller -north.com makes use of the Certkiller -north.com SQLService1 service account and the SQL Server instance on Certkiller -DB02 makes use of the Certkiller -south.com SQLService2 service account. You have been informed by the CIO that there are no mirroring endpoints on either server. Certkiller -DB01 contains a database named CK_DATA. The CIO wants you to mirror CK_DATA to Certkiller -DB02 by using high-protection mode without a witness. You need to create the database mirroring endpoints as well as configuring security on all participating server instances.
What should you do?
A.
You need to configure the database mirroring endpoints and security for every server instance by making use of the Transact-SQL.
Thereafter you should permit database mirroring to use encrypted certificates for outbound and inbound connections.
B.
You need to create endpoints and configure security using the Configure Database Mirroring Security Wizard for CK_DATA. The endpoints can then be set up to use SQL Server Authentication.
C.
You need to connect to every server instance and perform the following statement.
CREATE ENDPOINT mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5022 )
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS NTLM,
ROLE=PARTNER);
D.
You need to create logins and add them to the sysadmin group.
These logins should be configured to use SQL Server Authentication on every server instances.
Thereafter you can create endpoints using the Configure Database Mirroring Security Wizard on the Database Properties Mirroring page for CK_DATA.
Explanation:
The TCP Endpoint for mirroring has to be created with the T-SQL command:
CREATE ENDPOINT [Mirroring]
AS TCP (LISTENER_PORT = 5022)
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = REQUIRED); ALTER ENDPOINT [Mirroring] STATE = STARTED;
Any communication between the endpoints can be encrypted. You will thus have to specify which encryption algorithm to use for the communications. The default algorithm is RC4.