Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 972

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

Select any node in the operator tree and look at the number of micro-partitions scanned.

Find the operator node with the highest fraction of time or percentage of total time.

Select the TableScan operator node and look at the percentage scanned from cache.

Look at the number of rows between operator nodes across the operator tree.

Correct Answer: B

To identify the costliest operator of a query using the Query Profile, find the operator node with the highest fraction of time or percentage of total time. This approach will highlight the nodes that have the most significant impact on query performance, helping to pinpoint bottlenecks and areas for optimization.

Discussion

MarkantiOption: B

B is correct https://docs.snowflake.com/en/user-guide/ui-query-profile

converteo_certifOption: B

Answer B : Operator Nodes by Execution Time: A collapsible panel in the operator tree pane lists nodes by execution time in descending order, enabling users to quickly locate the costliest operator nodes in terms of execution time. The panel lists all nodes that lasted for 1% or longer of the total execution time of the query (or the execution time for the displayed query step, if the query was executed in multiple processing steps). https://docs.snowflake.com/en/user-guide/ui-query-profile