Exam 70-764 topic 1 question 255 discussion

Actual exam question from Microsoft's 70-764

Question #: 255
Topic #: 1

You are troubleshooting an application that runs a query.
The application frequently causes deadlocks. You need to identify the isolation level used by the query when a deadlock occurs.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

A. Query the sys.dm_exec_requests dynamic management view.
B. Create a trace in SQL Server Profiler that contains the Deadlock graph event.
C. Query the sys.dm_exec_sessions dynamic management view.
D. Enable trace flag 1222, and then view the SQL Server error log.

Show Suggested Answer

Suggested Answer: C 🗳️
- sys.dm_exec_sessions
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a serverscope view that shows information about all active user connections and internal tasks. Include the column: transaction_isolation_level smallint
Transaction isolation level of the session.
0 = Unspecified
1 = ReadUncomitted
2 = ReadCommitted
3 = Repeatable
4 = Serializable
5 = Snapshot Is not nullable.

by Bobbywewdw at April 21, 2020, 4 a.m.

Comments

Submit Cancel

Bobbywewdw

5 years, 1 month ago

C will not identify if session is invloved in a deadlock. Answer is D.

upvoted 2 times

Iva10

4 years, 12 months ago

There is deadlock priority column in this view, so the answer is C. https://books.google.hr/books?id=_M8YJTApyWsC&pg=PA147&lpg=PA147&dq=sys.dm_exec_sessions+deadlock&source=bl&ots=ujR9mTpHWP&sig=ACfU3U3k7vuA0afTqJqWiShgPtYjqn4e8g&hl=hr&sa=X&ved=2ahUKEwiI1oeww43qAhWLjYsKHej_CA4Q6AEwAHoECAkQAQ#v=onepage&q=sys.dm_exec_sessions%20deadlock&f=false

upvoted 1 times

RohitRaj2311

4 years, 7 months ago

Along with deadlock priority, it also contains transaction_isolation_level column which question is asking for. So answer C is correct.

upvoted 1 times

...