HOTSPOT
You are a database administrator for a company. Database auditing captures activity from the human resources department users when they add records to the table. You need to find the status and location of audit logs and then open the logs for review.
Which system functions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point
Answer:
Explanation:
Box 1: sys.dm_server_audit_status sys.dm_server_audit_status provides information about the current state of the audit.
Box 2: Sys.server_file_audits Sys.server_file_audits contains extended information about the file audit type in a SQL Server audit on a server instance.
Box 3: Sys.fn_get_audit_file Sys.fn_get_audit_file returns information from an audit file created by a server audit in SQL Server.