Following objects can be cloned in snowflake

The correct answer is A. Permanent table B. Transient table D. External tables. In Snowflake, cloning creates a zero-copy clone that shares the underlying micro-partitions with the source. Permanent tables (A) and transient tables (B) are fully supported for cloning. External tables (D) can also be cloned - the clone references the same external data…

Snowflake Architecture

Question

Options

APermanent table
BTransient table
CTemporary table
DExternal tables
EInternal stages

How the community answered

(55 responses)

A
87% (48)
C
4% (2)
E
9% (5)

Explanation

In Snowflake, cloning creates a zero-copy clone that shares the underlying micro-partitions with the source. Permanent tables (A) and transient tables (B) are fully supported for cloning. External tables (D) can also be cloned - the clone references the same external data location. Temporary tables (C) cannot be cloned because they are session-scoped objects and do not persist beyond the current session, making them incompatible with the clone operation. Internal named stages (E) cannot be cloned; Snowflake explicitly excludes them from cloning operations. When cloning a database or schema, any internal stages within it are not included in the clone.

Topics

#Zero-copy cloning#Snowflake objects#Table types#Data management

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice