YOU ARE CREATING NEW SERVICE BROKER OBJECTS FOR A NEW SQL SERVICE...

16. You are creating new service Broker objects for a new sQL service

Broker application. The iT department coding standards require that

when contracts are defined you must specify the message type used for the

source and destination. You are creating your new services and are defining

your message types. Which code block is the correct code block to use?

A.

CREATE CONTRACT YourContract AUTHORIZATION dboSourceMessageType SENT BY ANY,DestinationMessageType SENT BY ANY;

B.

CREATE CONTRACT YourContract AUTHORIZATION dboSourceMessageType SENT BY INITIATOR,

c.

CREATE CONTRACT YourContract AUTHORIZATION dboDestinationMessageType SEND BY TARGET;