SnowPro Core Certification — Question 1050
How does conditional data masking work in Snowflake?
Answer options
- A. It selectively masks plain text data.
- B. It selectively masks multiple columns.
- C. It masks all values in a given column.
- D. It selectively masks a column value based on another column.
Correct answer: D
Explanation
The correct answer, D, describes how conditional data masking operates by adjusting the visibility of a column's value depending on the data in a different column. Option A is incorrect because it does not specify the conditional aspect of masking. Option B is incorrect as it suggests multiple columns can be masked but does not address the condition. Option C is wrong because it indicates that all values are masked, rather than selectively.