SnowPro Core Certification — Question 971

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: B

Explanation

The correct answer is B because the operator with the highest fraction of time indicates it is the most resource-intensive part of the query. The other options either focus on irrelevant metrics such as cache usage or micro-partition counts, which do not directly correlate to the cost of the operators.