Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solutio

n that might meet the stayed goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questi

ons will not appear on the review screen.

You plan to configure auditing for a Microsoft SQL Server instance that contains 17 databases.

You need to audit all of the SELECT statements that are executed against all of the databases. The solution must

ensure that all gathered information is written to the application log.

Solution: You create a Server Audit Specification in the master database.

Does this meet the goal?

A. Yes

B. No

Explanation:

An auditing policy can be defined for a spec

ific database or as a default server policy. A server policy applies to all existing and newly created databases on the server.

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing