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.)
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.
B: Zero-copy cloning in Snowflake allows for efficient creation of clones that share the underlying storage and metadata with the original object. However, if developers need to work with production data that has specific columns masked (potentially using different views or transformations), a direct copy of the data may be necessary to apply these transformations without affecting the original production data.
C: When developers require a separate Snowflake account for development and testing purposes, especially in scenarios where they need to work independently and may need to modify the data structure or content significantly, a copy of the production data into the development/testing account ensures isolation and control over their own environment. Zero-copy cloning does not provide this level of isolation between different Snowflake accounts.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
meng
3 months, 4 weeks agoMSIDDIQUI18
4 months, 2 weeks ago