COF-C02 · Question #411
Which Snowflake feature can be used to find sensitive data in a table or column?
The correct answer is B. Data classification. Data Classification in Snowflake proactively scans table columns and assigns semantic categories (e.g., NAME, EMAIL, PHONE_NUMBER) and privacy categories (e.g., IDENTIFIER, QUASI_IDENTIFIER) to help discover where sensitive or PII data lives. Masking policies (A) protect…
Question
Which Snowflake feature can be used to find sensitive data in a table or column?
Options
- AMasking policies
- BData classification
- CRow level policies
- DExternal functions
How the community answered
(42 responses)- A2% (1)
- B90% (38)
- C2% (1)
- D5% (2)
Explanation
Data Classification in Snowflake proactively scans table columns and assigns semantic categories (e.g., NAME, EMAIL, PHONE_NUMBER) and privacy categories (e.g., IDENTIFIER, QUASI_IDENTIFIER) to help discover where sensitive or PII data lives. Masking policies (A) protect already-known sensitive columns but don't discover them. Row-level policies (C) restrict row access based on criteria but don't identify sensitivity. External functions (D) invoke external services for computation, not data discovery.
Topics
Community Discussion
No community discussion yet for this question.