Home » Microsoft » 70-465 » What should you include in the recommendation?
You need to recommend a solution to ensure that USP_4 adheres to the security requirements.
What should you include in the recommendation?
A. Enable SQL Server Audit.
B. Enable trace flags.
C. Configure data manipulation language (DML) triggers.
D. Enable C2 audit tracing.
Correct Answer: A
Explanation/Reference:
Explanation:
* Scenario: A stored procedure named USP_4 calls stored procedures in the Sales, Customers, and Inventory databases. The nested stored procedures read tables from the Sales, Customers, and Inventory databases. USP_4 uses an EXECUTE AS clause.
* Beginning in SQL Server 2008 Enterprise, you can set up automatic auditing by using SQL Server Audit.
Reference: SQL Server Audit (Database Engine)