Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 745

The Query Profile in the image is for a query executed in Snowsight. Four of the key nodes are highlighted in yellow.

Which highlighted node will be the MOST expensive?

    Correct Answer: D

    The most expensive node in a query execution plan typically corresponds to the one consuming the highest percentage of total execution time. In the provided query profile, the

Discussion
MarcusbragaOption: D

D: https://www.examtopics.com/exams/snowflake/snowpro-core/view/11/

MultiCloudIronManOption: D

correct

karthikn_0002

can you explain?

0e504b5

https://docs.snowflake.com/en/user-guide/ui-query-profile 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). Execution Time Provides information about which processing tasks consumed query time (described in Query/Operator Details below). Additionally, for step-level information, it shows the state of the given step, and its execution time.

0e504b5

Execution time provides information about “where the time was spent” during the processing of a query