Provisioning SQL Databases — Question 45

You administer a Microsoft SQL Server 2012 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, which is designed to track specific server-level events and log them to the Application Log. Options A, D, F, and E do not specifically target logging into the Application Log for changes to server roles, while B (a Policy) and C (an Alert) are not suitable for this purpose either.