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?

A. Yes

B. No

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 SE

RVER 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