
Answer-first summary for fast verification
Answer: A single data type, with one or more conditions, and one or more masking functions
According to Snowflake documentation and the community discussion with strong consensus (100% agreement and multiple upvoted comments), a masking policy consists of a single data type, one or more conditions, and one or more masking functions. Option A is correct because: (1) A masking policy is defined for a single data type but can be applied to multiple columns of that type across databases and schemas; (2) It can have multiple conditions using conditional expressions, context functions, or entitlement tables; (3) It can use multiple masking functions including built-in functions, UDFs, or external functions. Options B, C, and D are incorrect because they impose incorrect restrictions - B limits to only one condition and one function, C incorrectly states multiple data types, and D also incorrectly states multiple data types.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What are the components of a masking policy in Snowflake?
A
A single data type, with one or more conditions, and one or more masking functions
B
A single data type, with only one condition, and only one masking function
C
Multiple data types, with only one condition, and one or more masking functions
D
Multiple data types, with one or more conditions, and one or more masking functions