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 destina-

tion. 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;

Answer C is the correct solution. Although answers A and B will correctly create

the contract, those two code samples do not meet the IT department coding

standards, which require that contracts are defined with specific definitions so that

the message type can be used by only one side of the application.