Where can masking policies be applied in Snowflake?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Where can masking policies be applied in Snowflake?

Explanation:
Masking policies control how sensitive data is revealed by targeting the data at the column level. They’re defined once and then attached to a specific column in a table or in a view. When a query runs, Snowflake evaluates the policy using the query context (such as the caller’s role) and returns either the real value, a redacted/masked value, or NULL, depending on the policy logic. Because of this, masking policies are inherently tied to a column, not to a database, schema, or other objects like network paths. You apply them by attaching the policy to a column in a table or a view, for example through an ALTER TABLE ... MODIFY COLUMN ... SET MASKING POLICY policy_name. This is why the correct interpretation is that masking policies can be applied to a table or view column.

Masking policies control how sensitive data is revealed by targeting the data at the column level. They’re defined once and then attached to a specific column in a table or in a view. When a query runs, Snowflake evaluates the policy using the query context (such as the caller’s role) and returns either the real value, a redacted/masked value, or NULL, depending on the policy logic. Because of this, masking policies are inherently tied to a column, not to a database, schema, or other objects like network paths. You apply them by attaching the policy to a column in a table or a view, for example through an ALTER TABLE ... MODIFY COLUMN ... SET MASKING POLICY policy_name. This is why the correct interpretation is that masking policies can be applied to a table or view column.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy