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:
http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx
G
G
DATABASE_PRINCIPAL_CHANGE_GROUP
This event is raised when principals, such as users, are created, altered, or dropped from a database.
https://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx