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:
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 Adult configured to send audit event records to a file. You need to ensure that a database user named User1 can review the audit data. Solution: You assign the db_datareader role to User1. Does this meet the goal?
Correct Answer: B
Explanation/Reference: 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