PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. However, recently CK_Prod has
produced deadlock problems. You have received instructions from management to get the
deadlocks on the SQL Server error log.

What should you do? (Choose TWO)

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider using the SQL Profiler trace.

B.
You should consider enabling the Server Auditing for CK_Prod.

C.
You should consider setting up the trace flags and reboot the SQL Server instance.

D.
You should consider using the Transactions Log.


Leave a Reply