You administer a Microsoft SQL Server 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
You administer a Microsoft SQL Server database named Contoso on a server named Server01. You need to track all SELECT st
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You administer a Microsoft SQL Server database named Contoso on a server named Server01. You need to track all SELECT st
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!