exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1222 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 1222
Topic #: 1
[All SnowPro Core Questions]

When cloning a schema, which Snowflake object will not be included in the clone?

  • A. An external stage
  • B. A named internal stage
  • C. A task
  • D. A User-Defined Function (UDF)
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
5915c35
1 week, 1 day ago
Selected Answer: B
When cloning a database or schema: External named stages that were present in the source when the cloning operation started are cloned. Tables are cloned, which means the internal stage associated with each table is also cloned. Any data files that were present in a table stage in the source database or schema are not copied to the clone (i.e. the cloned table stages are empty). Internal named stages are not cloned. reference : snowflake documentation
upvoted 1 times
...
37ceea2
3 weeks ago
Selected Answer: A
Named Internal Stages and External Tables, cannot be cloned. But, External Stages and Pipes for EXTERNAL STAGES, CAN BE CLONED.
upvoted 1 times
37ceea2
3 weeks ago
Sorry. I selected wrongly: right answer is B.
upvoted 1 times
...
...
MatthieuDN
3 weeks, 4 days ago
Selected Answer: A
A is correct https://docs.snowflake.com/en/sql-reference/sql/create-clone#:~:text=statement%20is%20executed.-,Not%20cloned,Internal%20(Snowflake)%20stages,-Pipes
upvoted 1 times
MatthieuDN
3 weeks, 3 days ago
My bad I wanted to type B
upvoted 1 times
...
...
Jiten732
3 weeks, 6 days ago
Selected Answer: B
Named internal stage will not be replicated/cloned to the new schema. External Stage can be cloned
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago