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

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

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
meng
3 months, 4 weeks ago
Selected Answer: BC
B: Maksing policy can not be cloned C: Need a share, not a clone
upvoted 2 times
...
MSIDDIQUI18
4 months, 2 weeks 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 ...