Exam SnowPro Core topic 1 question 861 discussion

AB The efficiency of pruning can be observed by comparing Partitions scanned and Partitions total statistics in the TableScan operators. If the former is a small fraction of the latter, pruning is efficient. If not, the pruning did not have an effect.

AC is correct A. Partitions scanned: This statistic indicates the number of data partitions (or micro-partitions in Snowflake's terms) that were actually accessed during the execution of a query. Efficient query pruning will reduce the number of partitions scanned because it avoids reading data that does not match the query's filters. A lower number compared to the total available partitions can show that query pruning has effectively reduced the dataset that needed to be scanned. C. Bytes scanned: This statistic shows the volume of data scanned to fulfill the query. Just like with partitions scanned, effective query pruning should reduce the amount of data that needs to be scanned, as it skips over blocks of data that are determined (via metadata inspection) not to contain relevant data. This can significantly enhance query performance, especially in large datasets.

AB - correct https://docs.snowflake.com/en/user-guide/ui-query-profile