Which statement about CREATE TABLE ... CLONE is correct?

• A. Creates a new table with no data.
• B. Creates an empty copy of an existing table.
• C. Creates a clone of an existing table.
• D. Creates a view.

Answer: (C)

This is about zero-copy cloning of a table. CREATE TABLE ... CLONE makes a new table that is a true clone of an existing one, but it doesn’t copy all the data upfront. Snowflake creates a new metadata reference to the same underlying data blocks, so the clone initially contains the same data and schema as the source at the moment of cloning. Because of copy-on-write, the storage is shared until either table is modified, at which point only the changed blocks are copied. This makes cloning fast and space-efficient and gives you a separate table you can query or modify independently later. The option that suggests no data or an empty copy isn’t accurate for a clone, and cloning isn’t creating a view.