SnowPro Advanced: Architect — Question 113

A company needs to set up Snowflake with the ability to use zero-copy cloning from a production environment to keep data fresh in development and QA environments. Data from the development and QA environments can never be joined to the production environment data in queries.

How can these requirements be met?

Answer options

• A. Create a single Snowflake account with production, development, and QA schemas in all databases. Separate the roles for each environment by enabling secondary roles for all users.
• B. Create a single Snowflake account that includes production, development, and QA databases. Create separate roles for each of the environments.
• C. Create separate Snowflake accounts for production, development, and QA. Replicate the data from the production account to the development and QA accounts.
• D. Create separate Snowflake accounts for production, development, and QA. Establish data sharing from the production account to the development and QA accounts. Enable secondary roles for all users.

Correct answer: C

Explanation

The correct answer is C because creating separate Snowflake accounts for each environment ensures that data isolation is maintained, preventing any potential joins between production and non-production data. Options A and B do not provide the necessary isolation required by the scenario, while option D, while introducing data sharing, still does not meet the requirement to keep development and QA environments entirely separate from production.