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 ret

urn 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 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 ANY DEFINITION 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 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