Get Complete Q&A from 70-762 Exam Questions

70-762 Exam Dumps | You have a database that is…

Question: 2

You have a database that is experiencing deadlock issues when users run queries.

You need to ensure that all deadlocks are recorded in XML format.

What should you do?

A. Create a Microsoft SQL Server Integration Services package that uses
sys.dm_tran_locks.
B. Enable trace flag 1224 by using the Database Cpmsistency Checker(BDCC).
C. Enable trace flag 1222 in the startup options for Microsoft SQL Server.
D. Use the Microsoft SQL Server Profiler Lock:Deadlock event class.

Answer: C

Leave a Reply

Your email address will not be published. Required fields are marked *