Administering a SQL Database Infrastructure — Question 238

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 a named instance on a server than runs Microsoft SQL Server 2016 Standard edition.
Does the solution meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution does not achieve the goal because SQL Server 2016 Web edition does not support database-level auditing, and migrating to a named instance on SQL Server 2016 Standard edition does not automatically enable this feature. Thus, the answer is No, as the migration alone is insufficient to meet the auditing requirement.