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

Explanation:

To audit users in a role use a Database Audit Specification.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-audit-specification-transact-sql