Answer-first summary for fast verification
Answer: Shows how the accessed data was moved from the source to the target objects, Provides a unified picture of what data was accessed and when it was accessed
The ACCESS_HISTORY view in Snowflake provides comprehensive audit trail information for data access operations. Option A is correct because it shows how data moves from source to target objects, which is essential for tracking data lineage and understanding data flow patterns. Option B is correct because it provides a unified view of what data was accessed and when, enabling comprehensive monitoring and auditing of data usage. The community discussion strongly supports AB with 88% consensus and multiple upvoted comments referencing Snowflake documentation that confirms these capabilities. Options C, D, and E describe different Snowflake features: C describes Dynamic Data Masking, D describes Classification and Tagging, and E describes Row Access Policies - none of which are functions of the ACCESS_HISTORY view.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How does the Access_History view improve data governance for read and write operations? (Choose two.)
A
Shows how the accessed data was moved from the source to the target objects
B
Provides a unified picture of what data was accessed and when it was accessed
C
Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime
D
Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data
E
Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy
No comments yet.