Exam 70-464 topic 1 question 44 discussion

Actual exam question from Microsoft's 70-464

Question #: 44
Topic #: 1

You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent users.
You need to log all of the queries to DB1 that become deadlocked. The solution must meet the following requirements:
✑ Provide a representation of the deadlock in XML format.
✑ Minimize the impact on the server.
What should you create?

A. A SQL Server Profiler trace
B. A SQL Server Agent job that retrieves information from the sys.dm_tran_session_transactions dynamic management views
C. A SQL Server Agent job that retrieves information from the sys.dm_tran_active_transactions dynamic management views
D. A script that enables trace flags

Show Suggested Answer

Suggested Answer: A 🗳️

by Kepty at Nov. 22, 2020, 8:04 p.m.