In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
A . Bytes scanned
B . Bytes sent over the network
C . Number of partitions scanned
D . Percentage scanned from cache
E . External bytes scanned

View Answer

Answer: A, C

Explanation:

In the query profiler view, the components that represent areas that can be used to help optimize query performance include ‘Bytes scanned’ and ‘Number of partitions scanned’. ‘Bytes scanned’ indicates the total amount of data the query had to read and is a direct indicator of the query’s efficiency. Reducing the bytes scanned can lead to lower data transfer costs and faster query execution. ‘Number of partitions scanned’ reflects how well the data is clustered; fewer partitions scanned typically means better performance because the system can skip irrelevant data more effectively.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Query Profiling1