PrepAway - Latest Free Exam Questions & Answers

Which Transact-SQL statement should you use?

You created a Service Broker queue by using the following Transact-SQL statement:

CREATE QUEUE VacationRequestQueue WITH RETENTION = OFF, ACTIVATION (
PROCEDURE_NAME = dbo.VacationRequestProcess,
MAX_QUEUE_READERS = 5, EXECUTE AS SELF
);

You need to modify the Service Broker queue to prevent it from processing received messages.
The queue should continue to receive messages.
Which Transact-SQL statement should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
ALTER QUEUE VacationRequestQueue WITH RETENTION = ON;

B.
ALTER QUEUE VacationRequestQueue WITH STATUS = OFF;

C.
ALTER QUEUE VacationRequestQueue WITH ACTIVATION (STATUS = OFF);

D.
ALTER QUEUE VacationRequestQueue WITH ACTIVATION (EXECUTE AS OWNER);


Leave a Reply