70-433 · Question #4
You created a Service Broker queue by using the following Transact-SQL statement: CREATE QUEUE VacationRequestQueue WITH RETENTION = OFF, ACTIVATION ( PROCEDURE_NAME = dbo.VacationRequestProcess…
The correct answer is C. ALTER QUEUE VacationRequestQueue. ALTER QUEUE VacationRequestQueue WITH RETENTION = ON; sets the VacationRequestQueue queue to retain messages. The queue retains all messages sent to or from services that use this queue until the conversation that contains the message ends. ALTER QUEUE VacationRequestQueue WITH…
Question
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?
Options
- AALTER QUEUE VacationRequestQueue
- BALTER QUEUE VacationRequestQueue
- CALTER QUEUE VacationRequestQueue
- DALTER QUEUE VacationRequestQueue
How the community answered
(39 responses)- A13% (5)
- B3% (1)
- C79% (31)
- D5% (2)
Explanation
ALTER QUEUE VacationRequestQueue WITH RETENTION = ON; sets the VacationRequestQueue queue to retain messages. The queue retains all messages sent to or from services that use this queue until the conversation that contains the message ends. ALTER QUEUE VacationRequestQueue WITH STATUS = OFF; makes the VacationRequestQueue queue unavailable to receive messages. ALTER QUEUE VacationRequestQueue WITH ACTIVATION (STATUS = OFF); the queue does not activate the stored procedure. ALTER QUEUE VacationRequestQueue WITH ACTIVATION (EXECUTE AS OWNER); specifies that the stored procedure executes as the owner of the queue.
Topics
Community Discussion
No community discussion yet for this question.