Exam DEA-C02 Topic 1 Question 249 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 249
Topic #: 1

Your company is implementing data governance policies in Snowflake and wants to automatically classify data to track Personally Identifiable Information (PII). You have defined a classification policy with a tag 'PII' and associated tag values like 'Email', 'CreditCard', and 'SSN'. You want to monitor the usage of PII data'. Which of the following approaches is the MOST efficient way to track access and modifications to columns tagged with the 'PII' tag and any of its tag values?

A. Create a scheduled task to query the INFORMATION SCHEMCOLUMNS view and filter based on the TAG DATABASE, TAG SCHEMA, and TAG NAME columns to identify PII columns, then query the QUERY_HISTORY view and filter based on the identified column names. B. Create a masking policy that redacts all PII data. Monitor access attempts via the ACCESS HISTORY view. Although it hinders data usability, this approach guarantees no PII data leakage and allows easy monitoring. C. Enable Snowflake's data governance features, including object tagging and data classification. Then, leverage the ACCESS HISTORY view, filtering based on POLICY _ TAGS. This will show all accesses to data tagged as PII. D. Implement a custom UDF that intercepts all queries. Inside the UDF, check if any of the accessed tables or columns are tagged with 'PII', and log those queries into a separate logging table for monitoring. E. Use Snowflake's native data governance capabilities in conjunction with Snowflake Horizon to actively monitor data quality and access patterns, specifically focusing on PII-tagged columns.

Suggested Answer: C Vote an answer

The ACCESS HISTORY view, when combined with Snowflake's object tagging and data classification features, provides the MOST efficient way to monitor access to data tagged with specific tags like 'PII'. Filtering based on POLICY _ TAGS allows you to quickly identify accesses related to PII data. Option A is less efficient due to the need for continuous polling and parsing potentially large query histories. Option B excessively restricts data usability. Option D incurs significant overhead and maintenance costs. Option E, while involving Horizon, doesn't primarily rely on Horizon for access monitoring of tagged data; Horizon is more aligned with data discovery and cataloging.

by Olivia at Dec 08, 2025, 08:11 AM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business