Exam DP-700 topic 3 question 6 discussion

Use sys.dm_exec_sessions. This view has info about all active user sessions, including user names, session IDs and status.

E is correct

select distinct nt_user_name from sys.dm_exec_sessions where nt_user_name is not null

Option View Name Purpose A sys.dm_exec_connections Shows connection info, not detailed query/user-level execution. B sys.dm_exec_requests Shows active requests including user and query details. C queryinsights.long_running_queries Shows historical long-running queries, not real-time monitoring. D queryinsights.frequently_run_queries Shows frequently run queries, not active users or sessions. E sys.dm_exec_sessions Shows session-level info, but lacks specifics about running queries.

sys.dm_exec_connections: This view returns information about the current connections to the database instance, such as the client IP address, the login time, and the number of reads and writes. It focuses on connection details rather than identifying specific user queries. sys.dm_exec_requests: This view provides information about requests currently executing on the server, including the session ID, request status, and resource consumption. While it can show active requests, it doesn’t necessarily identify the specific users running the queries. The sys.dm_exec_sessions view, on the other hand, contains information about all active user connections and internal tasks, including details like the session ID and login name. This makes it more suitable for identifying which users are actively running queries in your database.

sys.dm_exec_sessions is a server-scope view that shows information about all active user connections and internal tasks

sys.dm_exec_sessions