SnowPro Core Certification — Question 254

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

Answer options

• A. Bytes scanned
• B. Bytes sent over the network
• C. Number of partitions scanned
• D. Percentage scanned from cache
• E. External bytes scanned

Correct answer: A, C

Explanation

The correct answers, A (Bytes scanned) and C (Number of partitions scanned), indicate the amount of data and the number of data segments involved in the query, both critical for identifying performance bottlenecks. Options B, D, and E do not directly indicate areas for optimizing performance in the same way, as they either relate to network usage or caching rather than the core query execution metrics.