Microsoft
70-466 · Question #73
70-466 Question #73: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Configure and maintain an analysis services 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
- Aan Extended Events session
- Ba SQL Server Profiler template
- Clog errors by using trace flag 1204
- Dlog errors by using trace flag 1222
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 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#real-time monitoring#SQL Server tracing