Exam DEA-C02 Topic 1 Question 36 Discussion

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

A data engineer is implementing a data governance policy that requires masking PII data in non-production environments. They have identified a column 'CUSTOMER EMAIL' that needs to be masked. They want to use dynamic data masking in Snowflake, but the 'CUSTOMER EMAIL' column is referenced in several views. Which of the following approaches is MOST appropriate and avoids breaking the existing views?

A. Create a masking policy directly on the 'CUSTOMER EMAIL' column in the base table. This will automatically apply the masking to all views referencing the column. B. Create a separate view that applies the masking function to the 'CUSTOMER EMAIL' column. Replace all existing views with the new masked view. C. Create a masking policy on the base table, but exclude the role used by the views from the policy's condition. This will prevent masking for those specific views. D. Create masking policies on each of the individual views that reference the 'CUSTOMER EMAIL' column, using the same masking function. E. Create a masking policy on the base table but use a context function in the masking policy condition to check the database name. Mask the data only when the database name is the non-production database.

Suggested Answer: A Vote an answer

Applying the masking policy directly on the column in the base table is the most efficient and least disruptive approach. Snowflake's dynamic data masking automatically propagates to all views that reference the column, ensuring consistent masking without requiring changes to the views themselves. Option B requires replacing views, which can be time-consuming and error-prone. Option C attempts to bypass masking for views, which defeats the purpose of the data governance policy. Option D requires managing masking policies on multiple views, increasing complexity. Option E is also correct but option A will be more appropiate, as in option E, the masking policy will still run in the Production environment. The overhead of Context function.

by Corey at Aug 30, 2025, 04:29 PM

Limited Time Offer

15%

Off

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

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business