Home » Microsoft » 70-764 v.2 » What should you create?
You administer a Microsoft SQL Server 2016 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
Correct Answer: G
Explanation/Reference:
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 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