Answer: Micro-partitioning happens when the data is loaded

The correct answer is C because micro-partitioning in Snowflake occurs automatically when data is loaded, without requiring manual configuration. This is a fundamental characteristic of Snowflake's architecture where data is transparently partitioned based on the order of insertion. Option A is incorrect because micro-partitioning is designed to minimize data skew through automatic optimization. Option B is incorrect as no partitioning schema needs to be defined by users; it's automatic. Option D is incorrect because micro-partitioning cannot be disabled—it's a core feature of Snowflake's storage architecture. The community discussion strongly supports C with unanimous agreement and references to official documentation.

Author: LeetQuiz Editorial Team