SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ39

Data Storage and Processing

A company uses a single Snowflake account for both its production and non-production environments. An Architect must design a solution that defines the different database layers and includes a process for periodically refreshing data from production to non-production, with data governance that protects columns containing sensitive data.

How should the layers be configured, and which process should be followed?

Explanation

A RAW → Integration → Presentation architecture separates ingested source data, transformed and conformed data, and consumer-facing data. Scheduled tasks can periodically clone the identified production tables into non-production. Dynamic Data Masking is Snowflake’s column-level security mechanism: masking policies can return data according to the querying role, protecting sensitive column values. Row access policies instead control which rows a role can see.

Learn more

Community Discussion

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