What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)
What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)
Snowflake stores metadata concerning all rows stored in a micro-partition. This includes the range of values for each of the columns in the micro-partition, which helps in efficient query processing and optimization. Additionally, it includes the number of distinct values for each column in the micro-partition, which is also used for optimization purposes.
DE, according to the doc https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions Snowflake stores metadata about all rows stored in a micro-partition, including: The range of values for each of the columns in the micro-partition. The number of distinct values. Additional properties used for both optimization and efficient query processing. AD according to my testing I ran the following queries. Only COUNT (DISTINCT) used the warehouse. Scanned only 1 partition. This contradicts the documentation> select min(cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center; select max(cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center; select count(distinct cc_call_center_sk) from snowflake_sample_data.tpcds_sf100tcl.call_center; select count(*) from snowflake_sample_data.tpcds_sf100tcl.call_center; Also see related Q157
correct answer. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions
Snowflake stores metadata about all rows stored in a micro-partition, including the range of values for each of the columns in the micro-partition and the number of distinct values