
Answer-first summary for fast verification
Answer: Data masking policies
The question requires allowing some users to see full PII while restricting others from seeing the full values. Data masking policies (Option B) are specifically designed for this purpose - they can dynamically mask sensitive data based on user roles or attributes, showing full values to authorized users and masked/partial values to others. Row access policies (Option A) control access to entire rows, not partial visibility of column values. Data encryption (Option C) protects data at rest/in transit but doesn't control visibility. Role-based access control (Option D) manages permissions but doesn't provide granular masking capabilities. The community discussion strongly supports B with 85% consensus and multiple upvoted comments explaining that masking policies allow selective visibility while row policies control row-level access entirely.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company needs to allow certain users to view Personally Identifiable Information (PII) while restricting other users from seeing the full PII values.
Which Snowflake feature supports this requirement?
A
Row access policies
B
Data masking policies
C
Data encryption
D
Role based access control
No comments yet.