Which dynamic management view provides details about SQL commands running in the data warehouse?

• A. sys.dm_exec_connections
• B. sys.dm_exec_sessions
• C. sys.dm_exec_requests
• D. sys.dm_exec_query_stats

Answer: (B)

To see what SQL commands are running in the data warehouse, you look at runtime state provided by dynamic management views that expose active sessions. The session-focused view gives you one row per active session, including who is connected and when their activity started, and you can retrieve the exact statement being executed for that session by querying the associated SQL text (via joining with the text view). This makes it the most direct way to map a live command to the user or session that issued it.

Other DMVs serve different angles: the connections view shows connection details, not the running commands; the requests view reports current requests but without the broader session context; and the query stats view aggregates historical performance rather than showing the current, in-flight SQL text. Thus, the per-session view is the best starting point for details about SQL commands currently running in the data warehouse, especially when you pair it with the SQL text retrieval.