DP-300 Certification Practice Question #135

Question

You have an Azure subscription that contains an Azure SQL database.
The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To identify resource_semaphore waits, you need to query `sys.dm_exec_requests` which contains real-time information about each active request including its `wait_type`. Selecting `wait_type` and grouping/ordering by it reveals which waits are occurring (including `RESOURCE_SEMAPHORE`). `sys.dm_exec_requests` has a `session_id` column that enables the join with `sys.dm_exec_sessions`. The other options lack the required `session_id` column for the join.

More DP-300 practice questions