What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
Cloning a table in Snowflake is advantageous because the clone is created almost instantly, allowing for rapid duplication of tables without significant delay. Additionally, the clone saves space by not duplicating storage, which means it does not initially create a full copy of the data but rather shares the existing data storage with the original table until changes are made.
C and E are correct
https://docs.snowflake.com/en/sql-reference/sql/create-clone.html
C,E are correct
C and E are correct.
C - Cloning is fast, but not instantaneous, particularly for large objects (e.g. tables).
corrected to C&E
i think C E
CD - correct answers. The question ask about the advantage of clones OVER tables created with a statement CREATE TABLE AS SELECT ... Both tables (clone and the one created with the statement) do not copy the underlaying data, so there is NO advantage of a clone over the other table.
Correct
C - Cloning is fast, but not instantaneous, particularly for large objects (e.g. tables). - so ALMOST is correct
D - Incorrect - Time travel data is not available for table T1_CLONE. The requested time is either beyond the allowed time travel period or before the object creation time.
If a table is cloned, historical data for the table clone begins at the time/point when the clone was created. --> this makes option D incorrect for option C, noticing "almost" is important
I am going for D&E after going through https://docs.snowflake.com/en/sql-reference/sql/create-clone may be D option is hinting towards creation time of clone it will copy data from time travel