SnowPro Advanced: Architect — Question 96

Assuming all Snowflake accounts are using an Enterprise edition or higher, in which development and testing scenarios would copying of data be required, and zero-copy cloning not be suitable? (Choose two.)

Answer options

• A. Developers create their own datasets to work against transformed versions of the live data.
• B. Production and development run in different databases in the same account, and Developers need to see production-like data but with specific columns masked.
• C. Data is in a production Snowflake account that needs to be provided to Developers in a separate development/testing Snowflake account in the same cloud region.
• D. Developers create their own copies of a standard test database previously created for them in the development account, for their initial development and unit testing.
• E. The release process requires pre-production testing of changes with data of production scale and complexity. For security reasons, pre-production also runs in the production account.

Correct answer: B, C

Explanation

Option B is correct because it describes a situation where specific data masking is required, making zero-copy cloning unsuitable. Option C is also correct since it involves transferring data from a production account to a different development account, which cannot be achieved with zero-copy cloning. The other options either do not require actual data copies or can utilize zero-copy cloning effectively.