SnowPro Core Certification — Question 420

Which view will return users who have queried a table?

Answer options

• A. SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_EVENT_HISTORY
• B. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY
• C. SNOWFLAKE.ACCOUNT_USAGE.COLUMNS
• D. SNOWFLAKE.ACCOUNT_USAGE.OBJECT_DEPENDENCIES

Correct answer: B

Explanation

The correct answer is B, as SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY tracks user access to tables and other objects within Snowflake. The other options do not provide user query information; for instance, A focuses on warehouse events, C lists column details, and D shows dependencies between objects.