PrepAway - Latest Free Exam Questions & Answers

What should you do?

You use Service Broker to manage data requests between SQL Server 2005 databases.

You need to make changes to objects for an existing service. You want to ensure that no messages can be received

by the service until the changes are complete.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create the queue with ACTIVATION STATUS OFF. Set it to ON when the service is ready.

B.
Create the queue with STATUS OFF. Set it to ON when the service is ready.

C.
Create the queue with only the queue_name argument. Set the other parameters when the service is ready.

D.
Create the queue with max_queue_readers = 0. Set it to an optimum value when the service is ready.


Leave a Reply