Snowflake allows setting a masking policy on a materialized view column.

• A. False
• B. Partially true
• C. Depends on the object
• D. True

Answer: (D)

Masking policies are defined on a column and enforced when data is read. A materialized view exposes columns just like a regular view, so you can attach a masking policy to a materialized view column in the same way you would for a table or a standard view. When someone queries the materialized view, Snowflake evaluates the policy for that column based on the caller’s role and returns either the real value or a masked value. The fact that the data is materialized doesn’t bypass the policy—the policy is applied at read time, not stored data. So yes, you can set a masking policy on a materialized view column.