Snowflake Data Engineer Practice Exam

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.