How does conditional data masking work in Snowflake?
How does conditional data masking work in Snowflake?
Conditional data masking in Snowflake selectively masks a column value based on conditions that can be related to other columns or criteria within the same table. This allows for dynamic masking based on defined rules or policies, enabling granular control over which data is masked, depending on the data in another column or specific condition met.
D https://community.snowflake.com/s/article/How-to-conditionally-mask-a-column-in-a-table-based-on-a-subquery-from-a-different-table
And I think it is C. The key word in the question is 'selectively', I understand it so that the masking policy masks only part of values in a given column, when actually the masking policy masks ALL values in a given column for a particular role. So, if you have Role_A, you either see full values (for example: email addresses) or masked values.
changing to D
A. It selectively masks plain text data - because conditional data masking does involve selectively masking data based on certain conditions or criteria. However, it's important to clarify that these conditions are often related to user roles or other security measures rather than the content of the data itself. The key feature of conditional data masking is its ability to dynamically display either the original data or a masked version of the data based on the evaluation of these conditions.