Microsoft
70-433 · Question #3
70-433 Question #3: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
Question
You have a database named Contoso. The Contoso database has a Service Broker queue named VacationRequestQueue. The Contoso database has been restored to a new server. Since restoring the database, Service Broker is no longer able to send new messages. You need to configure Service Broker in order to resolve the issue. Which Transact-SQL statement should you use?
Options
- AALTER DATABASE Contoso SET NEW_BROKER;
- BALTER DATABASE Contoso SET ENABLE_BROKER;
- CALTER QUEUE VacationRequestQueue WITH STATUS = ON;
- DALTER QUEUE VacationRequestQueue WITH ACTIVATION (STATUS = ON);
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.