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.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-audit-specification-transactsql