Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1040

How are micro-partitions enabled on Snowflake tables?

Micro-partitioning requires a cluster key on a table.

Micro-partitioning is automatically performed on a table.

Micro-partitioning requires the use of the search optimization service.

Micro-partitioning is defined by the user when a table is created.

Correct Answer: B

Micro-partitioning in Snowflake is automatically performed on a table. Snowflake organizes the data into micro-partitions without requiring any action from the user. This process is transparent and optimizes how data is stored and queried.

Discussion

NachoPrendesOption: B

B https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#:~:text=Micro%2Dpartitioning%20is%20automatically%20performed%20on%20all%20Snowflake%20tables.%20Tables%20are%20transparently%20partitioned%20using%20the%20ordering%20of%20the%20data%20as%20it%20is%20inserted/loaded.