PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. The Sony database has the problems of deadlock .You should make sure that
you could catch the deadlock data to the SQL Server error log. Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should make Server Auditing enable for the Products database.

B.
You should set a Transactions Log to capture the deadlock graphs.

C.
You should set a SQL Profiler trace to capture the deadlock graphs.

D.
As a startup parameter, you should configure the proper trace flags and restart the SQL Server instance.


Leave a Reply