DP-300 Certification Practice Question #273

Question

You have an Azure SQL database.
You need to identify whether a delayed query execution is associated to a RESOURCE_SEMAPHORE wait.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To check if active, delayed queries are experiencing a `RESOURCE_SEMAPHORE` wait, you must inspect currently executing queries and their wait statistics. The dynamic management view `sys.dm_exec_requests` lists all currently executing requests, including their active `session_id`, `wait_type`, and `wait_time`. Joining this with `sys.dm_exec_sessions` filters for user processes. Projecting and grouping by the `wait_type` allows aggregating total wait time to identify resource bottlenecks.

More DP-300 practice questions