Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 419

What is a characteristic of data micro-partitioning in Snowflake?

Micro-partitioning may introduce data skew

Micro-partitioning requires the definition of a partitioning schema

Micro-partitioning happens when the data is loaded

Micro-partitioning can be disabled within a Snowflake account

Correct Answer: C

Micro-partitioning in Snowflake refers to the automatic and transparent partitioning of data as it is loaded into Snowflake tables. This means that the process takes place during the data loading phase, without the need for a predefined partitioning schema. Micro-partitions optimize query performance and storage but are managed entirely by Snowflake, removing the need for manual intervention.

Discussion

miadieselOption: C

Micro-partitioning is automatically performed on all Snowflake tables. Tables are transparently partitioned using the ordering of the data as it is inserted/loaded. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html#what-are-micro-partitions

psilvabrOption: C

C is the right one.

_yyuktaOption: C

C. Micro-partitioning happens when the data is loaded

MultiCloudIronManOption: C

correct

KnightVictorOption: C

C for sure