Answer: Automatically

Micro-partitions in Snowflake are automatically generated as data is loaded into tables. Snowflake automatically manages the creation, maintenance, and optimization of micro-partitions without requiring manual intervention. While users can influence micro-partition organization through CLUSTER BY statements for performance optimization, the fundamental generation of micro-partitions happens automatically during data loading operations. Options B, C, and D are incorrect because ORDER BY [], PARTITION BY [], and GROUP BY [] are SQL clauses used for query operations (sorting, window functions, and aggregation respectively) and do not control micro-partition generation.

Author: LeetQuiz Editorial Team