Administering Microsoft SQL Server 2012/2014 Databases — Question 59

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a Microsoft SQL Server 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, because it is specifically designed to track and log server-level actions such as adding or removing users from fixed server roles. The other options do not provide the same level of detail for logging these specific events or are intended for different purposes, such as monitoring performance or enforcing policies.