Microsoft
70-459 · Question #27
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the following…
Sign in or unlock 70-459 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
Maintain a database
Question
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the following requirements: - Support real-time monitoring. - Be enabled and disabled easily. - Support querying of the monitored data. What should you implement? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- Aa SQL Server Profiler template
- Ban Extended Events session
- Clog errors by using trace flag 1204
- Dlog errors by using trace flag 1222
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#deadlock monitoring#Extended Events#trace flags#real-time monitoring