
Answer-first summary for fast verification
Answer: A materialized view, A table
Masking policies in Snowflake can be applied to columns in tables and materialized views. According to Snowflake documentation and the community discussion consensus (100% agreement on AC), masking policies are schema-level objects that can be set on table columns using ALTER TABLE commands and on materialized view columns using ALTER VIEW commands. The other options are incorrect: stored procedures (B) are code objects that don't have columns to mask, streams (D) are change data capture objects that don't support masking policies, pipes (E) are data loading objects, and UDFs (F) are function objects that don't have columns for masking policies.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.