Exam SnowPro Advanced Architect topic 1 question 135 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 135
Topic #: 1

[All SnowPro Advanced Architect Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by ArunH at Nov. 26, 2025, 7:05 p.m.

Comments

Submit Cancel

ArunH

23 hours, 44 minutes ago

Selected Answer: B

The requirement is to zero copy cloning feasible to keep dev env fresh. Replication wont meet that. B is the best chance where join or usage can be prevented using role priviliges

upvoted 1 times

...