Answer-first summary for fast verification
Answer: Micro-partitioning is automatically performed on a table.
According to Snowflake documentation and the community discussion with 100% consensus, micro-partitioning is automatically performed on all Snowflake tables without any user intervention. Tables are transparently partitioned using the ordering of the data as it is inserted/loaded. Option B is correct because micro-partitioning is an automatic feature. Option A is incorrect because cluster keys are optional for performance optimization but not required for micro-partitioning. Option C is incorrect because the search optimization service is a separate feature that can enhance query performance but is not required for micro-partitioning. Option D is incorrect because users do not define micro-partitioning when creating tables; it happens automatically.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How are micro-partitions managed in Snowflake tables?
A
Micro-partitioning requires a cluster key on a table.
B
Micro-partitioning is automatically performed on a table.
C
Micro-partitioning requires the use of the search optimization service.
D
Micro-partitioning is defined by the user when a table is created.
No comments yet.