YOU ARE SETTING UP YOUR DEPLOYMENT SCRIPTS TO CREATE YOUR DATABASE...

5. You are setting up your deployment scripts to create your database mirroring

endpoints on your production SQL Server. Each server has a single instance on

it. Which script will correctly create the database mirroring endpoint?

A.

CREATE ENDPOINT MyEndpointSTATE = STARTEDAS HTTP (PATH=/sql/MyEndpoint, AUTHENTICATION=BASIC)FOR DATABASE_MIRRORING;

B.

AS TCP (LISTENER_PORT=5022)

C.

CREATE DATABASE_MIRRORING ENDPOINT MyEndpointSTATE=STARTEDAS TCP (LISTENER PORT=5022);

D.

AS TCP (LISTENER PORT=1433)

Answer B is the correct answer. Database mirroring endpoints must use

unique TCP port numbers. Answer C uses an invalid command, because the

DATABASE_MIRRORING switch goes after the protocol section. Answer D

is incorrect because port 1433 will be used by the SQL Server engine.