70-431 Microsoft SQL Server 2005 - Implementation and Maintenance Online Class

Microsoft ™

70-431 Microsoft SQL Server 2005 - Implementation and Maintenance

Note 1: 70-431 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-431 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 10.

You are employed as a database administrator at EliteCertify.com. The EliteCertify.com network consists of a single Active Directory domain named EliteCertify.com. The EliteCertify.com network contains a SQL Server 2005 database named EliteCertify -DB03. You have received several reports from users' stating that they received deadlock error messages in an order processing application. You monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want data regarding every participant in the deadlock. What should you do?

A. You need to trace the Lock:Deadlock event by making use of the SQL Server Profiler.
B. You need to trace the Lock:Timeout event on EliteCertify -DB03 by making use of the SQL Server Profile.
C. You need to trace the Lock:Deadlock Chain event on EliteCertify -DB03 by using the SQL Server Profiler.
D. You needs to trace the SQLServer:Locks - Number of Deadlocks/sec counter on EliteCertify -DB03 by using System Monitor.

Display Answer

Purchase Full Version:

70-431 Printable PDF Prep Guide $49.95 BUY NOW!

70-431 Test Simulation Engine $69.95 BUY NOW!

70-431 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: C

Explanation: Use SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic dependency between two or more threads or processes for some set of resources within SQL Server. Using SQL Server Profiler, you can create a trace that records, replays and displays deadlock events for analysis.