What does the waittype column, RESOURCE_QUEUE indicates
A. You may notice this waittype during the long-running I/O-bound operations such as creating, expanding, or dropping a database file
B. This waittype indicates that a batch has been received from a client application but that there are no worker threads that are available to service the request
C. These waittypes are all involved in parallel query execution
D. This is an ordinary idle state for background threads in SQL Server
Answer:D
What does the waittype column, RESOURCE_QUEUE indicates
A. You may notice this waittype during the long-running I/O-bound operations such as creating, expanding, or dropping a database file B. This waittype indicates that a batch has been received from a client application but that there are no worker threads that are available to service the request C. These waittypes are all involved in parallel query execution D. This is an ordinary idle state for background threads in SQL Server