Snowpro Core · Free Practice Question Medium
Question 46
When a database or a schema is cloned, which of the following objects will NOT be cloned?
-
A
Internal Snowflake Stages
-
B
External Tables
-
C
Snowpipes that point to a Named Internal Snowflake Stage
-
D
Transient Tables
-
E
Permanent Tables
Reveal correct answers
Correct answers: A, B, C
Explanation
Cloning for an external table is not supported. The data for external tables sits outside Snowflake; therefore, cloning an external table does not work.
Named Internal Stages cannot be cloned.
When a database or schema is cloned, any Snowpipe that points to a Named Internal Stage is not cloned.
https://docs.snowflake.com/en/user-guide/object-clone
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
