PrepAway - Latest Free Exam Questions & Answers

What should you do?

Your company has a network that consists of two domains named DOM1 and DOM2. There is no trust relationship between DOM1 and DOM2. DOM1 contains a server named SQL1.
DOM2 contains a server named SQL2. Both servers run SQL Server 2005. The SQL Server instance on SQL1 uses the DOM1SQLService1 service account. The SQL Server instance on SQL2 uses the DOM2SQLService2 service account. There are no mirroring endpoints on either server. SQL1 contains a database named DB1. You want to mirror DB1 to SQL2 by using high-protection mode without a witness. You need to create the database mirroring endpoints and configure security on all participating server instances. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create endpoints and configure security by using the Configure Database Mirroring Security Wizard for DB1. Set up the endpoints to use SQL Server Authentication.

B.
Configure database mirroring endpoints and security for each server instance by using Transact-SQL.
Allow database mirroring to use encrypted certificates for outbound and inbound connections.

C.
Create logins and add them to the sysadmin group. Configure the logins to use SQL Server Authentication on each of the server instances. Create endpoints by using the Configure Database Mirroring Security Wizard on the Database Properties Mirroring page for DB1.

D.
Connect to each server instance and execute the following statement.
CREATE ENDPOINT mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5022 )
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS NTLM,
ROLE=PARTNER);


Leave a Reply