Microsoft
70-457 · Question #138
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…
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
How the community answered
(43 responses)- A7% (3)
- B2% (1)
- C5% (2)
- F84% (36)
- G2% (1)
Community Discussion
No community discussion yet for this question.