What is a feature of column-level security in Snowflake?

The correct answer is A. Role access policies. Snowflake's column-level security is implemented through masking policies that are role-based - meaning the policy evaluates the active role of the querying user and conditionally reveals or masks the column value. This role-driven conditional access is the core mechanism…

Account Access and Security

Question

Options

ARole access policies
BNetwork policies
CInternal tokenization
DExternal tokenization

How the community answered

(46 responses)

A
93% (43)
B
4% (2)
D
2% (1)

Explanation

Snowflake's column-level security is implemented through masking policies that are role-based - meaning the policy evaluates the active role of the querying user and conditionally reveals or masks the column value. This role-driven conditional access is the core mechanism (referred to here as 'role access policies'). Network policies (B) govern IP-based access at the account/user level. Internal tokenization (C) is not a Snowflake feature. External tokenization (D) is a related but distinct feature that integrates with third-party tokenization services.

Topics

#Column-level security#Masking policies#Access control#Role-based access control

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice