Explanation:AUDIT_XE_SESSION_MGR occurs when there is a wait on a lock that is used to synchronize the starting and stopping of audit related Extended Events sessions. 8. When does BROKER_TO_FLUSH wait type event occurs ?
A. When the Service Broker queue task handler tries to shut down the task.
B. When the Service Broker transmitter is waiting for work
C. When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table.
D. All of the mentioned
Answer:A
Explanation:AUDIT_XE_SESSION_MGR occurs when there is a wait on a lock that is used to synchronize the starting and stopping of audit related Extended Events sessions. 8. When does BROKER_TO_FLUSH wait type event occurs ?
A. When the Service Broker queue task handler tries to shut down the task. B. When the Service Broker transmitter is waiting for work C. When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table. D. All of the mentioned
Explanation:BROKER_SHUTDOWN tries to shut down the task. 9. Which of the following wait type is for internal use only ?