Which Snowflake feature can be used to find sensitive data in a table or column?
Which Snowflake feature can be used to find sensitive data in a table or column?
Data classification is the feature that can be used to find sensitive data in a table or column. It helps to identify and classify sensitive information so that appropriate measures can be taken to secure it. Masking policies and row-level policies are used to control access to the data, not to find it.
Correct
Why not masking policies?
Classification will let you find sensitive data. Masking policies are used to mask sensitive data after you found them. Dynamic Data Masking is a Column-level Security feature that uses masking policies to selectively mask plain-text data in table and view columns at query time https://docs.snowflake.com/en/user-guide/security-column-ddm-intro https://docs.snowflake.com/en/user-guide/governance-classify-concepts