Administering a SQL Database Infrastructure — Question 134

You administer a Microsoft SQL Server 2016 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?

Answer options

• A. an Extended Event session
• B. a Policy
• C. a Database Audit Specification
• D. an Alert
• E. a Server Audit Specification
• F. a SQL Profiler Trace
• G. a Resource Pool

Correct answer: F

Explanation

The correct answer is F, a SQL Profiler Trace, because it allows you to capture and replay events such as deadlocks in SQL Server. The other options, like Extended Events or Audit Specifications, do not provide the same level of detailed event capture and replay functionality needed for diagnosing specific deadlock issues.