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?
Select one answer.
Marked answer: C
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Chose C1
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
Chose C1
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.
Chose C1
But it is not "shared", is "replicated". And we can create a clone from a replicated database. It's C
Keyboard:←→previous / next·A–Echoose·Entercheck, then next
