You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com uses Service Broker to manage data requests between SQL Server 2005 databases. You have received instruction from the CIO to make changes to objects for an existing service. You need to make sure that no messages can be received by the service until the changes are complete.
What should you do?
A.
You should create the queue with max_queue_readers = 0.
Thereafter you should set it to an optimum value as soon as the service is ready.
B.
You should create the queue with ACTIVATION STATUS OFF.
Then you should set it to ON when the service is ready.
C.
You should create the queue with STATUS OFF and set it to ON as soon as the service is ready.
D.
You should create the queue with only the queue_name argument.
Thereafter you can set the other parameters once the service is ready.
Explanation:
The STATUS clause determines whether the queue is enabled. When a queue is set to
STATUS = OFF, it does not permit any messages to be added to or removed from the queue.