When does BROKER_TO_FLUSH wait type event occur?

A) When the Service Broker transmitter is waiting for work

B) When the Service Broker queue task handler tries to shut down the task

C) When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table

D) All of the above

Correct Answer : When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table

Explanation : BROKER_SHUTDOWN tries to shut down the task.

Top Trending Technologies MCQ's

Machine Learning

Artificial Intelligence

Natural Language Processing

Top Trending Technologies Interview Questions