You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts two database named CK_Sales and CK_Inventory. You create a Service Broker to enable the CK_Sales and CK_Inventory databases to communicate. You want to create a new service named // Domain.com/Income.
What should you do first?
A.
Create the queue.
B.
Create the contract.
C.
Create a database view.
D.
Create a new database instance.
Explanation:
The CREATE SERVICE statement must have an ON QUEUE clause to specify which queue it should use. Therefore you must create the queue first.
Incorrect Answers:
B: The CREATE SERVICE statement can specify a contract if it must listen for a contract. If the CREATE SERVICE statement does not specify the contract, then that service can only initiate a conversation.
C: You do not need to create a database view based on the two databases but you do need to create the queue that the service will use.
D: You do not need to create a new database instance but you do need to create the queue that the service will use.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: CREATE SERVICE statement