Answer-first summary for fast verification
Answer: Query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema.
The correct answer is C because the ACCESS_HISTORY view in the ACCOUNT_USAGE schema provides comprehensive audit trail information about who accessed which database objects in Snowflake. This view specifically tracks access patterns and user interactions with database objects, making it the appropriate tool for identifying users who accessed sensitive data. Option A (reviewing granted privileges) only shows who has permission to access objects, not who actually accessed them. Option B (reviewing row access policies) shows security policies but not actual access events. Option D (REPLICATION_USAGE_HISTORY) is unrelated to user access tracking and focuses on replication operations. The community discussion shows 100% consensus on answer C with supporting documentation reference.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can a Snowflake administrator identify the user who accessed a database object containing sensitive information?
A
Review the granted privileges to the database object.
B
Review the row access policy for the database object.
C
Query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema.
D
Query the REPLICATION_USAGE_HISTORY view in the ORGANIZATION_USAGE schema.
No comments yet.