You are employed as a database administrator at Hi-tech Company. The Hi-tech Company network consists of a single Active Directory domain named Hi-tech Company. 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 DB_Data and another page of your application has controls which are used to execute stored procedures in a database named DB_Sales. Hi-tech Company has an existing Service Broker connection between the DB_Data and DB_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 DBReport and DBResult. 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 (DBReport SENT BY INITIATOR, DBResult SENT BY TARGET)
B.
A queue should be created on every database with the ACTIVATION argument set to DB_Data.dbo. DBReport.
C.
Services for every database needs to be created by using the subsequent statement:
CREATE SERVICE DB_Data
ON QUEUE DBReport
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 ‘ DBReport ‘ TO SERVICE ‘ DBResult ‘