Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam SnowPro Advanced Architect topic 1 question 108 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 108
Topic #: 1
[All SnowPro Advanced Architect Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
MSIDDIQUI18
4 days, 11 hours ago
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
...
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.

SaveCancel
Loading ...
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in