exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 745 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 745
Topic #: 1
[All SnowPro Core Questions]

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?

  • A. Aggregate[1]
  • B. Join[5]
  • C. TableScan[2]
  • D. TableScan[3]
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Marcusbraga
1 year, 3 months ago
D: https://www.examtopics.com/exams/snowflake/snowpro-core/view/11/
upvoted 2 times
...
MultiCloudIronMan
1 year, 3 months ago
Selected Answer: D
correct
upvoted 1 times
karthikn_0002
1 year, 3 months ago
can you explain?
upvoted 2 times
0e504b5
9 months ago
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.
upvoted 1 times
0e504b5
9 months ago
Execution time provides information about “where the time was spent” during the processing of a query
upvoted 1 times
...
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago