DP-300 Deadlock Graph Practice Question
Your SQL Server is experiencing deadlocks. You enable trace flag 1222 to capture deadlock graphs in the error log. Where can you retrieve the deadlock information?
⚠ Common exam trap
Candidates may confuse trace flag 1222 with Extended Events or assume deadlock info is accessible via DMVs like sys.dm_exec_requests. However, trace flag 1222 outputs specifically to the error log.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The SQL Server error log, viewable using sp_readerrorlog.
Trace flag 1222 writes deadlock information to the SQL Server error log. This log can be read using sp_readerrorlog, xp_readerrorlog, or the Log File Viewer in SQL Server Management Studio. Option D refers to this error log, though retrieving it via sp_readerrorlog is the direct method; the original mention of sys.messages and sys.fn_get_audit_file is incorrect and replaced.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
sys.dm_exec_sessions
Why it's wrong here
sys.dm_exec_sessions contains current session information, not deadlock graphs.
- ✗
sys.query_store_query_text
Why it's wrong here
sys.query_store_query_text stores query text for Query Store, unrelated to deadlock information.
- ✗
sys.dm_exec_requests
Why it's wrong here
sys.dm_exec_requests shows current request details, not deadlock graphs.
- ✓
The SQL Server error log, viewable using sp_readerrorlog.
Why this is correct
Trace flag 1222 outputs deadlock graphs to the SQL Server error log, viewable via sp_readerrorlog or similar tools.
Go deeper
Related to this question
About these practice questions
One of 906 original DP-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.