Which two actions should you perform?

You have a Microsoft SQL Server instance that has a database named DB1. The database is used for reporting 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 down 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 Serve Audit.
B. Use Extended Events.
C. Use a logon trigger.
D. Create a SQL Server Profiler trace and disable c2 audit tracing.
E. Enable SQL Server Query Store.

microsoft-exams

One thought on “Which two actions should you perform?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.