問題文
A masking policy is attached to a column that holds national identifiers. An analyst whose role is not exempted queries the table and sees masked values. What is true about the data that Snowflake has stored?
選択肢
- The stored values were rewritten at the moment the policy took effect, which is what makes the protection durable even if someone later drops the policy without replacing it.
- A second copy of the table holds the raw values, and the policy decides which copy is read, so the raw copy stays available to the roles that are exempted from the policy.
- The stored values are unchanged, because the policy is applied when the column is projected rather than when the rows were written.
- The values are unchanged, but the policy is evaluated once at insert time and cached.