You are tasked with identifying Personally Identifiable Information (PII) within a Snowflake table named 'customer data'. This table contains various columns, some of which may contain sensitive information like email addresses and phone numbers. You want to use Snowflake's data governance features to tag these columns appropriately. Which of the following approaches is the MOST effective and secure way to automatically identify and tag potential PII columns with the 'PII CLASSIFIED tag in your Snowflake environment, ensuring minimal manual intervention and optimal accuracy?
Correct Answer: B
Snowflake's built-in classification feature is the most effective because it uses machine learning models to automatically identify sensitive data with a high degree of accuracy. Associating masking policies with the identified columns provides additional data protection. Automated tagging further streamlines the governance process. Option A, while viable, requires custom code and maintenance. Option C is manual and error-prone. Option D is based solely on column names and can lead to false positives and negatives. Option E introduces unnecessary complexity and security risks by exporting data.