Exam 70-764 topic 2 question 9 discussion

Actual exam question from Microsoft's 70-764

Question #: 9
Topic #: 2

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 Server 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.

Show Suggested Answer

Suggested Answer: AD 🗳️
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

by Iva10 at March 11, 2020, 3:41 p.m.

Comments

Submit Cancel

Iva10

Highly Voted 5 years, 4 months ago

Why not B instead of D. Profiler is replaced with extended events.

upvoted 5 times

...