
Explanation:
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.
Ultimate access to all questions.
No comments yet.
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