nerdexam
Microsoft

MB7-700 · Question #95

Which tools does the SQL database engine provide for viewing deadlock information? Choose the 2 that apply.

The correct answer is A. Deadlock graph C. Trace flag 1204. See the full explanation below for the reasoning.

Question

Which tools does the SQL database engine provide for viewing deadlock information? Choose the 2 that apply.

Options

  • ADeadlock graph
  • BDatabase Engine Tuning Advisor
  • CTrace flag 1204
  • DTrace flag 4616

How the community answered

(26 responses)
  • A
    77% (20)
  • B
    15% (4)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full MB7-700 Practice