Which query should you execute?

HOTSPOT
You have a Microsoft Azure SQL database.
Some queries take a long time to execute.
You need to identify whether any of the long-running queries prevent users from updating data in the database.
Which query should you execute? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

Explanation/Reference:
Explanation:
Box 1: sys.dm_tran_locks sys.dm_tran_locks returns information about currently active lock manager resources in SQL Server 2017. Each row represents a currently active request to the lock manager for a lock that has been granted or is waiting to be granted.
Box 2: sys.dm_os_waiting_tasks sys.dm_tran_locks.lock_owner_address is the memory address of the internal data structure that is used to track this request.
This column can be joined the with resource_address column in sys.dm_os_waiting_tasks.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql?view=sql-server-2017