What should you create?

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

View Answer

Answer: G

Explanation:

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