Which statement is true of zero-copy cloning?
Which statement is true of zero-copy cloning?
Zero-copy cloning in Snowflake allows creating a cloned table that shares the micro-partitions with the original at the moment of creation. This means all the storage structures are duplicated without duplicating the data itself, thereby reducing additional storage costs until changes are made.
- Snowflake’s zero-copy cloning feature provides a convenient way to quickly take a “snapshot” of any table, schema, or database and create a derived copy of that object which initially shares the underlying storage. This can be extremely useful for creating instant backups that do not incur any additional costs (until changes are made to the cloned object). - owever, cloning makes calculating total storage usage more complex because each clone has its own separate life-cycle. This means that changes can be made to the original object or the clone independently of each other and these changes are protected through CDP. https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html#cloning-tables-schemas-and-databases
All micropartitions are shared at the moment of creation of cloned table, not afterwards, so in general the statement is not true
Micro-partitions are shared at the beginning, once changes are made to the copied table, the underlaying data changes and the tables may not share the same micro-partitions. Though it is true that once a table is cloned it inherits time-travel, clustering keys, comments, ... So I think it's B
D correct
It should be D
Nonevis true!
*None is true