SnowPro Core Certification — Question 1042

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because the ACCESS_HISTORY view in the ACCOUNT_USAGE schema logs information about who accessed which database objects. Options A and B do not provide user access information, as they focus on permissions and policies rather than access history. Option D pertains to replication history, which is unrelated to user access to database objects.