SnowPro Advanced Architect Exam - Question 23

Question

An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts.

The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis.

Which is the LEAST complex approach to use to populate the QA account with the Production account’s data and database objects on a nightly basis?

Examice · Accepted Answer

The least complex approach to populate the QA account with the Production account’s data and database objects on a nightly basis is to enable replication for each database in the Production account, create replica databases in the QA account, create clones of the replica databases nightly, and run tests directly on those cloned databases. Replication ensures that all changes including privileges are consistently mirrored, and cloning is a lightweight operation that allows for efficient creation of testable copies.

callipso21 · Answer

https://community.snowflake.com/s/article/How-to-Copy-a-Database-from-One-account-to-Another

Dhamod · Answer

https://community.snowflake.com/s/article/Snowflake-DTAP-Environment-Setup
Ans: C

victorleonis · Answer

Ans C is incorrect. We can clone a shared object.

anikl · Answer

Share database cannot be cloned. therefore A is wrong, C is correct

hillcat111 · Answer

Answer is C and is validated

rkarthik0789 · Answer

The least complex approach among the options provided is likely option B.
This approach involves setting up a shared stage between the Production and QA accounts and utilizing Snowpipe for data ingestion. Snowpipe can automatically load data from the stage into the QA environment, simplifying the process and reducing the need for manual intervention. Additionally, unloading data from the Production account into a stage is a straightforward task, and Snowpipe's automated data loading capabilities streamline the process further.

NachoPrendes · Answer

But it is not "shared", is "replicated". And we can create a clone from a replicated database. It's C

nareeshk · Answer

Lots of issues and gaps in question & options provided. There is no mention of region for prod and dev account, which dictates the choice between Share & replication.

Yogendra_examtopic · Answer

It's simple 
Question needs same privileges as of production
Share dosnt provide it but replication provide it 
So easiest way is replicate not share

SnowPro Advanced Architect Exam - Question 23

Discussion