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 64 discussion

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

What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Choose two.)

  • A. Any pipes in the source are not cloned.
  • B. Any pipes in the source referring to internal stages are not cloned.
  • C. Any pipes in the source referring to external stages are not cloned.
  • D. The clone inherits all granted privileges of all child objects in the source object, including the database.
  • E. The clone inherits all granted privileges of all child objects in the source object, excluding the database.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Atomic_Gecko
Highly Voted 3 months, 3 weeks ago
Correct answer is B & E, only pipes referencing external stages are cloned, and the clone inherits all grants to child objects but not the database itself
upvoted 5 times
...
cui_li
Most Recent 1 month, 1 week ago
Answer should be B & E. https://docs.snowflake.com/en/user-guide/object-clone When a database or schema is cloned, any pipes in the source container that reference an internal (i.e. Snowflake) stage are not cloned. However, any pipes that reference an external stage are cloned. If the source object is a database or schema, the clone inherits all granted privileges on the clones of all child objects contained in the source object: Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.
upvoted 4 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago