Can one masking policy be applied to multiple columns?

• A. False
• B. True
• C. Only in masked views
• D. Only in managed access schemas

Answer: (B)

A masking policy is reusable across multiple columns. You define the policy once and can attach the same policy to many columns in one or more tables, providing consistent masking rules without duplicating logic. When data is queried, Snowflake evaluates the policy for each column the policy is attached to, returning either the real value or a masked version depending on the session's role. You can apply it during table creation or later by altering each column to use the policy. This capability isn’t limited to masked views or to managed access schemas; it works with regular tables and columns as well.