Microsoft
70-457 · Question #138
70-457 Question #138: Real Exam Question with Answer & Explanation
The correct answer is F. a SQL Profiler Trace. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create?
Options
- Aan Extended Event session
- Ba Policy
- Ca Database Audit Specification
- Dan Alert
- Ea Server Audit Specification
- Fa SQL Profiler Trace
- Ga Resource Pool
Community Discussion
No community discussion yet for this question.