What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Adding a CLUSTER BY clause to a Snowflake table may colocalize data by the cluster key within the micro-partitions. This helps improve pruning performance, meaning that queries can skip irrelevant micro-partitions and thereby enhance query efficiency. The data organization helps to minimize the number of micro-partitions that need to be scanned for a query involving the cluster key.
I think D: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#benefits-of-defining-clustering-keys-for-very-large-tables
A clustering key is a subset of columns in a table (or expressions on a table) that are explicitly designated to co-locate the data in the table in the same micro-partitions. This is useful for very large tables where the ordering was not ideal (at the time the data was inserted/loaded) or extensive DML has caused the table’s natural clustering to degrade. https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#benefits-of-defining-clustering-keys-for-very-large-tables
D is correct
D is correct
D is good answer
that would be D
D is correct
ans is D.
must be D.