70-465 · Question #127
70-465 Question #127: Real Exam Question with Answer & Explanation
Sign in or unlock 70-465 to reveal the answer and full explanation for question #127. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2014 instance. Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues. You want to write a query of the system views that will report the following: - Number of users that have a connection to the server - Whether a user's connection is active - Whether any connections are blocked - What queries are being executed - Whether the database restore is still executing and, if it is, what percentage of the restore is complete. Which system objects should you use in your query to best achieve this task?
Options
- Asys.dm_exec_requests, sys.dm_exec_sessions, sys.objects
- Bsys.dm_exec_sessions, sys.dm_exec_query_stats, sys.dm_exec_query_text,sys.objects
- Csys.sysprocesses, sys.dm_exec_query_text, sys.objects
- Dsys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_query_text
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.