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?

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

Explanation:

The SQL Server Audit feature enables you to audit server-level and database-level groups of events and individual events.

Audits can have the following categories of actions:

• Server-level. These actions include server operations, such as management changes, such as in this question, and logon and logoff operations.
• Database-level. These actions encompass data manipulation languages (DML) and data definition language (DDL) operations.
• Audit-level. These actions include actions in the auditing process.

References: http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx