exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1286 discussion

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

How can a user access information about a query execution plan without consuming virtual warehouse compute resources?

  • A. Use the EXPLAIN function.
  • B. Review the Query Profile metrics.
  • C. Review the data in the Account_Usage view.
  • D. Use the Snowsight dashboard.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
37ceea2
3 weeks, 2 days ago
Selected Answer: B
Plan is available in Query Profile, as well.
upvoted 1 times
37ceea2
2 weeks, 6 days ago
https://docs.snowflake.com/en/sql-reference/sql/explain "EXPLAIN compiles the SQL statement, but does not execute it, so EXPLAIN does not require a running warehouse. Although EXPLAIN does not consume any compute credits, the compilation of the query does consume Cloud Service credits, just as other metadata operations do." The EXPLAIN plan is the “logical” explain plan. It shows the operations that will be performed, and their logical relationship to each other. The actual execution order of the operations in the plan does not necessarily match the logical order shown by the plan. Hence, it is not clear 100%. Let's say A., not B.
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