Answer-first summary for fast verification
Answer: Identification of unused data, Identification of who has read data
The ACCESS_HISTORY view in Snowflake's SNOWFLAKE database provides visibility into data access patterns. Based on the community discussion and official documentation references, the most supported benefits are: A (Identification of unused data) - confirmed by multiple comments with documentation links showing this as a primary benefit, and E (Identification of who has read data) - clearly supported as the view tracks user queries and data reads. Option D (Highlighting of row access policy usage) has some support but is less consistently validated. Options B and C are not well-supported - B (role usage) is better tracked through QUERY_HISTORY, and C (network policy usage) has specific alternative views. The consensus from higher-upvoted comments favors AE, with documentation evidence provided.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the benefits of using the ACCESS_HISTORY view in the Snowflake Data Cloud?
A
Identification of unused data
B
Identification of which roles have been used
C
Tracking of network policy usage
D
Highlighting of row access policy usage
E
Identification of who has read data
No comments yet.