Answer-first summary for fast verification
Answer: Query details such as the objects included and the user who executed the query
The ACCESS_HISTORY view in Snowflake's ACCOUNT_USAGE schema tracks query access patterns and object usage. According to Snowflake documentation and the community consensus (with 100% agreement and upvoted comments), option C is correct because ACCESS_HISTORY specifically stores query execution details including which objects were accessed and who executed the queries. Option A is incorrect because file loading history is tracked in LOAD_HISTORY. Option B is incorrect because role information is found in SESSION_ROLES or ROLE_HIERARCHY views. Option D is incorrect because privilege details are stored in GRANTS_TO_ROLES or GRANTS_TO_USERS views.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What data is contained in the ACCESS_HISTORY view?
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