Administering a SQL Database Infrastructure — Question 244

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.
You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01.
What should you create?

Answer options

• A. a Database Audit Specification
• B. a Policy
• C. an Alert
• D. a SQL Profiler Trace
• E. a Resource Pool
• F. an Extended Event session
• G. a Server Audit Specification

Correct answer: G

Explanation

The correct answer is G, a Server Audit Specification, as it is specifically designed for tracking and logging events, such as user role changes, to the Application Log. The other options do not provide the same level of logging capability for server role changes or are not specifically targeted for logging events in the Application Log.