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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *