YOU ARE MANAGING A SYSTEM THAT USES SQL SERVICE BROKER. YOU WISH T...

11. You are managing a system that uses sQL service Broker. You wish

to pause the automatic processing of messages that arrive sporadically

without stopping messages from being delivered into the queue. Which

command should you use?

A.

ALTER QUEUE YourQueueWITH STATUS=OFF;

B.

ALTER QUEUE YourQueueWITH ACTIVATION (STATUS=OFF);

c.

ALTER QUEUE YourQueueWITH ACTIVATION (PAUSE=TRUE);

D.

ALTER QUEUE YourQueueWITH MAX_QUEUE_READERS=0;