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