Administering a SQL Database Infrastructure — Question 188
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 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?
Answer options
- A. Yes
- B. No
Correct answer: B
Explanation
Granting the VIEW ANY DEFINITION permission allows User1 to view the definitions of database objects but does not provide access to the actual audit data stored in files. Therefore, this solution does not meet the goal of allowing User1 to review the audit data. The correct approach would involve permissions specifically related to accessing the audit logs.