Which two actions should you perform?

You have a Microsoft SQL Server instance that has database named DBI. The database is used purposes. You plan to capture all queries for a specific table and save the data as a text file.

You need to ensure that queries are captured and that a failure to capture a query will shut the SQL Server instance.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . Enable SQL Server Audit.
B . Use Extended Events.
C . Use a logon trigger.
D . Create a SQL Server profile trace disable c2 audit tracing.
E . Enable SQL Server Query Store.

View Answer

Answer: A,D

Explanation:

The general process for creating and using an audit is as follows.

Create an audit and define the target.

Create either a server audit specification or database audit specification that maps to the audit. Enable the audit specification. Enable the audit. Read the audit events by using the Windows Event Viewer, Log File Viewer, or the fn_get_audit_file function.

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server­audit-database-engine