Explanation:Examples of resource waits are locks, latches, network and disk I/O waits. Lock and latch waits are waits on synchronization objects. 7. Which of the following wait occurs when a task is waiting for I/Os to finish ?
A. ASYNC_NETWORK_IO
B. AUDIT_LOGINCACHE_LOCK
C. AUDIT_ON_DEMAND_TARGET_LOCK
D. AUDIT_XE_SESSION_MGR
Answer:A
Explanation:Examples of resource waits are locks, latches, network and disk I/O waits. Lock and latch waits are waits on synchronization objects. 7. Which of the following wait occurs when a task is waiting for I/Os to finish ?
A. ASYNC_NETWORK_IO B. AUDIT_LOGINCACHE_LOCK C. AUDIT_ON_DEMAND_TARGET_LOCK D. AUDIT_XE_SESSION_MGR
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 ?