ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 3 question 6 discussion

Actual exam question from Microsoft's DP-700
Question #: 6
Topic #: 3
[All DP-700 Questions]

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures.
You discover that the daily data load takes longer than expected.
You need to monitor Warehouse1 to identify the names of users that are actively running queries.
Which view should you use?

  • A. sys.dm_exec_connections
  • B. sys.dm_exec_requests
  • C. queryinsights.long_running_queries
  • D. queryinsights.frequently_run_queries
  • E. sys.dm_exec_sessions
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by GHill1982 at Jan. 1, 2025, 7:17 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
GHill1982
Highly Voted 4 months, 2 weeks ago
Selected Answer: E
Use sys.dm_exec_sessions. This view has info about all active user sessions, including user names, session IDs and status.
upvoted 8 times
doctordodge
3 months, 3 weeks ago
Don't we want to know about actively-running queries? Shouldn't we run sys.dm_exec_requests as that will give us that information? https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql?view=sql-server-ver16
upvoted 1 times
8d6881f
3 months, 2 weeks ago
I think the STATUS field in sys.dm_exec_sessions gives us that info
upvoted 1 times
...
...
...
prabhjot
Most Recent 2 months, 2 weeks ago
Selected Answer: E
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.
upvoted 2 times
...
38578c4
2 months, 2 weeks ago
Selected Answer: E
sys.dm_exec_sessions is a server-scope view that shows information about all active user connections and internal tasks
upvoted 1 times
...
Tuki93
3 months, 2 weeks ago
Selected Answer: E
sys.dm_exec_sessions
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago