SnowPro Core Recertification — Question 28

How can the Query Profile be used to identify the costliest operator of a query?

Answer options

• A. Select any node in the operator tree and look at the number of micro-partitions scanned.
• B. Find the operator node with the highest fraction of time or percentage of total time.
• C. Select the TableScan operator node and look at the percentage scanned from cache.
• D. Look at the number of rows between operator nodes across the operator tree.

Correct answer: C

Explanation

The correct answer is C because the TableScan operator's performance can be significantly affected by whether data is retrieved from cache or not, which directly impacts query cost. Options A and D provide insights into the query structure but do not specifically address cost efficiency. Option B focuses on time spent but does not consider the cache impact, which is crucial for understanding costs.