SnowPro Advanced: Architect — Question 11

An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows:
1. Use Tri-Secret Secure in Snowflake
2. Share some information stored in a view with another Snowflake customer
3. Hide portions of sensitive information from some columns
4. Use zero-copy cloning to refresh the non-production environment from the production environment
To meet these requirements, which design elements must be implemented? (Choose three.)

Answer options

• A. Define row access policies.
• B. Use the Business Critical edition of Snowflake.
• C. Create a secure view.
• D. Use the Enterprise edition of Snowflake.
• E. Use Dynamic Data Masking.
• F. Create a materialized view.

Correct answer: B, C, E

Explanation

The correct design elements are the Business Critical edition of Snowflake (B), which provides enhanced security features, a secure view (C) to share data securely, and Dynamic Data Masking (E) to hide sensitive information. The other options either do not meet all the requirements or pertain to editions of Snowflake that do not provide the necessary security features.