Administering a SQL Database Infrastructure — Question 98

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated 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 questions will not appear in the review screen.
A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instance that hosts a database named DB1.
You need to ensure that you can perform auditing at the database level for DB1.
Solution: You migrate DB1 to the default instance on a server that runs Microsoft SQL Server 2016 Standard edition.
Does the solution meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution does not meet the goal because Microsoft SQL Server 2016 Web edition does not support database-level auditing, and migrating to Standard edition, while it does support the feature, does not address the issue of the original instance's limitations. Therefore, simply migrating to a different edition will not enable the required auditing capabilities for DB1.