Answer: All micro-partitions between the original and cloned tables are fully shared

Based on the community discussion and Snowflake documentation, option D is the correct answer. Zero-copy cloning initially shares all micro-partitions between the original and cloned tables, which is the fundamental principle behind zero-copy cloning - no data duplication occurs at creation time. The storage is shared until changes are made to either table. Option A is incorrect because cloning does not increase storage costs initially (only when changes occur). Option B is incorrect as cloned tables do not inherit load history from the source. Option C is incorrect because zero-copy cloning is a standard Snowflake feature, not a licensed add-on. While some community members debated the 'fully shared' wording, the consensus and documentation confirm that micro-partitions are indeed fully shared at the moment of cloning.

Author: LeetQuiz Editorial Team