SnowPro Core Certification — Question 103

Which of the following statements is true of zero-copy cloning?

Answer options

• A. Zero-copy clones increase storage costs as cloning the table requires storing its data twice
• B. All zero-copy clone objects inherit the privileges of their original objects
• C. Zero-copy cloning is licensed as an additional Snowflake feature
• D. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared

Correct answer: D

Explanation

The correct answer is D because zero-copy cloning allows for immediate sharing of micro-partitions between the original and the clone, thus avoiding data duplication at the time of creation. Option A is incorrect as it suggests increased storage costs, which is not the case with zero-copy cloning. Option B is misleading as privileges may vary based on the user's access settings, and option C is inaccurate since zero-copy cloning is included in Snowflake's standard features.