Which statement is true regarding Row Access Policy for Materialized Views?

• A. Snowflake supports adding a row access policy to a materialized view provided that a row access policy is not set on the underlying table or view
• B. A materialized view cannot be created from a table or view if a row access policy is added to the underlying table or view
• C. A row access policy cannot be added to a table or view if a materialized view has been created from that underlying table or view
• D. All of the above

Answer: (B)

Row Access Policies filter which rows are visible at read time, while a materialized view stores a fixed, precomputed result. Snowflake cannot create a materialized view from a source that has an active row access policy because the MV would be built from data that the policy might later hide, leading to inconsistent results. That fundamental mismatch is why the statement is true: you cannot create a materialized view from a table or view if a row access policy is added to the underlying object. Snowflake also does not support attaching a row access policy directly to a materialized view, and the implication that policies can be added to the underlying object after an MV exists isn’t the supported behavior, so those options aren’t correct.