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 MyEndpoint

STATE = STARTED

AS HTTP (PATH=/sql/MyEndpoint, AUTHENTICATION=BASIC)

FOR DATABASE_MIRRORING;

B.

CREATE ENDPOINT MyEndpoint

AS TCP (LISTENER_PORT=5022)

C.

CREATE DATABASE_MIRRORING ENDPOINT MyEndpoint

STATE=STARTED

AS TCP (LISTENER PORT=5022);

D.

CREATE ENDPOINT MyEndpoint

AS TCP (LISTENER PORT=1433)