SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ37

Implement Data Protection and Recovery

A Data Engineer is configuring an environment in which Data Analysts can combine the CUSTOMERS and CUSTOMER_SALES tables to summarize customer sales by REGION. However, data-governance requirements require access to CUSTOMERID values to be restricted while still permitting use of the CUSTOMERID column to join the tables. To meet this requirement, the Engineer implemented a projection policy on the CUSTOMERID column.

What action should the Engineer take to ensure that Analysts can successfully perform the joins needed to retrieve REGION data from the CUSTOMERS table?

Explanation

Snowflake projection policies prevent a protected column from being projected in final query output, while still allowing the column to be used for joins. Applying the projection policy to CUSTOMERID in both tables prevents CUSTOMERID values from being exposed from either source and still permits the join needed to retrieve REGION.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!