PrepAway - Latest Free Exam Questions & Answers

What should you create?

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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply