Following objects can be cloned in snowflake
A. Permanent table
B. Transient table
C. Temporary table
D. External tables
E. Internal stages
Answer: A,B,E
Explanation:
In Snowflake, the ability to clone objects is an important feature for quickly duplicating the schema and data of various database objects. Here’s the capability of cloning the listed objects:
A. Permanent table
Yes, permanent tables can be cloned in Snowflake. The clone includes the data and schema of the table at the time of cloning.
B. Transient table
Yes, transient tables can also be cloned. Similar to permanent tables, the clone includes the data and schema of the transient table.
C. Temporary table
No, temporary tables cannot be cloned in Snowflake. Temporary tables are session-specific and are dropped automatically when the session ends.
D. External tables
No, external tables cannot be directly cloned in Snowflake. External tables point to data stored outside of Snowflake, typically in an external stage, and their metadata can be replicated or recreated, but not cloned in the same way as internal tables.
E. Internal stages
Yes, internal stages can be cloned in Snowflake. Cloning an internal stage creates a new stage with the same file format and other settings.
Therefore, the objects that can be cloned in Snowflake are:
A. Permanent table
B. Transient table
E. Internal stages
Latest ARA-C01 Dumps Valid Version with 156 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund