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.
http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx