Which Dynamic Management View enables viewing the active connections against a dedicated SQL pool?

The option that allows you to view the active connections against a dedicated SQL pool is sys.dm_pdw_exec_requests. This Dynamic Management View (DMV) provides insight into the currently executing requests, including details about the status, command, and the session associated with each request. Specifically for dedicated SQL pools in Azure Synapse Analytics, this DMV plays a crucial role in monitoring and managing performance by allowing administrators to see how many requests are active and to analyze their state.

In contrast, while sys.dm_pdw_dms_workers provides details about the distribution of workers in the dedicated SQL pool, it does not directly list active connections. DBCC PDW_SHOWEXECUTIONPLAN is used for retrieving execution plans for queries but does not focus on active connection details. Finally, sys.dm_exec_connections serves a similar purpose but is aimed at general SQL Server instances and not specifically tailored for the Azure Synapse Analytics dedicated SQL pool. Thus, sys.dm_pdw_exec_requests is the most appropriate choice for viewing active connections in this context.