SnowPro Core Certification — Question 486

What information is stored in the ACCESS_HISTORY view?

Answer options

• A. History of the files that have been loaded into Snowflake
• B. Names and owners of the roles that are currently enabled in the session
• C. Query details such as the objects included and the user who executed the query
• D. Details around the privileges that have been granted for all objects in an account

Correct answer: C

Explanation

The correct answer is C because the ACCESS_HISTORY view captures detailed information about queries executed, including the objects accessed and the user who performed the action. Options A, B, and D do not accurately describe the content of the ACCESS_HISTORY view, as they refer to other aspects of Snowflake rather than query execution details.