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.
Bạn đang xem 5. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P148 PPT