Question

Which of the following system views should you use to return a list of the actions and action groups associated with each database audit specification?

A. sys.audit_database_specifications_details
B. sys.server_audit_specifications_details
C. sys.server_audit_specifications
D. sys.server_audits

Answer 1

The correct system view to use is sys.audit_database_specifications_details.

Step-by-step explanation:

The correct system view to use in order to return a list of the actions and action groups associated with each database audit specification is sys.audit_database_specifications_details.

This view provides detailed information about database audit specifications, including the actions and action groups that are associated with each specification.

To retrieve the desired information, you can query the sys.audit_database_specifications_details view using a Transact-SQL statement.