SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ131

Secure Data Sharing and Consumption

An Architect is designing a Snowflake implementation that will share anonymized data from cell phone towers. The data will be shared with companies seeking to understand consumer spending patterns near major retail centers.

Because all Personally Identifiable Information (PII) must be anonymized, the design must provide the highest degree of separation of duties. The design must also support a full development cycle with separation between environments.

How can these requirements be satisfied?

Choose three
Explanation

A Git-enabled CI/CD workflow provides version control, validation, and repeatable automated deployment across the development lifecycle. Separate Snowflake accounts for each environment provide complete isolation between experimental development and production, restricting developer access to production resources. Dynamic masking policies protect sensitive PII at query time and support separation of duties by separating masking-policy administrators from object owners.

Learn more

Community Discussion

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