You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to write messages to the Application Log wh

en users are added to or removed from a fixed server role in Server01.

What should you create?

A. A Database Audit Specification

B. A Policy

C. An Alert

D. A SQL Profiler Trace

E. A Resource Pool

F. An Extended Event session

G. A Server Audit

Specification

Reference:

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to diagnose deadlocks that happen when exec

uting a specific set of stored procedures by recording events and playing them back on a different test server.

What should you create?

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

Reference:

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

You need to track all SELECT statements issued in the Contoso database only by users in a role named Sales.

What should you create?

A. An Alert

B.

A Resource Pool

C. An Extended Event session

D. A Server Audit Specification

E. A SQL Profiler Trace

F. A Database Audit Specification

G. A Policy

H. A Data Collector Set