Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
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?
Correct Answer: G
Explanation/Reference: 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 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