Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
The components in the Snowflake query profiler that help optimize query performance are Bytes scanned (A) and Number of partitions scanned (C). Bytes scanned (A) directly impacts performance, as reducing the volume of data processed through efficient filtering or clustering improves speed and cost. Number of partitions scanned (C) reflects partition pruning efficiency. Scanning fewer partitions (via proper clustering or filters) minimizes unnecessary data access. These metrics are critical for identifying bottlenecks in data retrieval and optimizing query execution.
Explanation: A. Bytes scanned Represents the total amount of data scanned during query execution. High values indicate that the query is scanning a large dataset, which can impact performance. Optimization: Reduce bytes scanned by applying filters, leveraging clustering, or optimizing table design. C. Number of partitions scanned Represents the number of partitions read during query execution. Scanning too many partitions can slow down query performance. Optimization: Use clustering, partition pruning, or query predicates to minimize the number of partitions scanned.
A and C should be the correct answers