What should you create?

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

View Answer

Answer: F