Can we clone a temporary table into a permanent one?

• A. True
• B. Only in certain Snowflake editions
• C. Only if the temporary table is created with a specific option
• D. False

Answer: (D)

Cloning copies the object with metadata intact, so the clone inherits the same lifecycle and scope as the source. A temporary table lives only for the session, and cloning it yields another temporary object rather than a permanent one. Since clone does not change an object's type or persistence, you cannot turn a temporary table into a permanent one by cloning. If you need a permanent version, create a permanent table and populate it from the temporary table, for example: CREATE TABLE permanent_tbl AS SELECT * FROM temp_tbl; This materializes the data into a permanent table while the temporary one can be dropped when appropriate.