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

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam
Go to Exam

Exam 70-462 topic 2 question 16 discussion

Actual exam question from Microsoft's 70-462
Question #: 16
Topic #: 2
[All 70-462 Questions]

You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?

  • A. SELECT * FROM sys.dm_exec_requests WHERE session_id = 60
  • B. SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60
  • C. DBCC INPUTBUFFER (60)
  • D. DBCC OPENTRAN
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by [deleted] at April 4, 2025, 11:25 a.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
Currently there are no comments in this discussion, be the first to comment!
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