Valid 70-764 Dumps shared by ExamDiscuss.com for Helping Passing 70-764 Exam! ExamDiscuss.com now offer the newest 70-764 exam dumps, the ExamDiscuss.com 70-764 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-764 dumps with Test Engine here:
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a server named Server1 that has Microsoft SQL Server installed. Server1 has SQL Server Audit configured to send audit even records to a file. You need to ensure that a database user named User1 can review the audit data. Solution: You grant the VIEW SERVER STATE permission to User1. Does this meet the goal?
Correct Answer: A
Explanation Each feature and command for SQL Server Audit has individual permission requirements. Unless otherwise specified, viewing catalog views requires a principal to have one of the following: * The VIEW SERVER STATE permission. * The VIEW AUDIT STATE permission (gives only the principal access to the sys.server_audits catalog view). * Membership in the sysadmin fixed server role. * The CONTROL SERVER permission. * The ALTER ANY AUDIT permission. A principal must have the VIEW SERVER STATE or ALTER ANY AUDIT permission to use the Dynamic Management Views. References: https://technet.microsoft.com/en-us/library/cc280665(v=sql.105).aspx