You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received instruction from the network CIO to create a Web-based application to manage data aggregation for reports. The Application that you create will connect to a SQL 2005 database named CK_Data and another page of your application has controls which are used to execute stored procedures in a database named CK_Sales.
Domain.com has an existing Service Broker connection between the CK_Data and CK_Sales databases. You have received additional instruction to add two new message types to the existing service. In each database, you create message types named CKReport and CKResult. You are required to add the two new message types to the existing service.
What should you do first?
A.
You have to create a contract between the services. This should be accomplished by using the subsequent statement:
CREATE CONTRACT ProcessReport
(CKReport SENT BY INITIATOR,
CKResult SENT BY TARGET)
B.
A queue should be created on every database with the ACTIVATION argument set to CK_Data.dbo. CKReport.
C.
Services for every database needs to be created by using the subsequent statement:
CREATE SERVICE CK_Data
ON QUEUE CKReport
D.
You have to create a conversation between the databases. This can be done by making use of the subsequent statement:
BEGIN DIALOG FROM SERVICE ‘ CKReport ‘
TO SERVICE ‘ CKResult ‘
Explanation:
A contract contains a list of message types and the services that are allowed to send them.
Syntax:
CREATE CONTRACT contract [AUTHORIZATION owner ]
( {{message_type_name | [DEFAULT ] }
SENT BY { INITIATOR | TARGET | ANY }
} [ ,…n] ) [;]
Key:
contract Name of the contract
owner Owner of the contract(database user or role)
message_type_name Name of a message type to be included