ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 1203 discussion

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

A complex query has been running in Snowsight for more than one hour. At the same time, several other queries from other worksheets ran successfully.

What is FASTEST way to cancel the long-running query?

  • A. Immediately suspend the virtual warehouse that the query is running on.
  • B. Return to the worksheet and abort the query.
  • C. Set the auto_suspend virtual warehouse property to 0.
  • D. Find the query in the query activity view and cancel the query.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by DerfelCardarn at Jan. 25, 2025, 7:15 p.m.

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
Submit Cancel
37ceea2
3 weeks, 1 day ago
Selected Answer: B
https://docs.snowflake.com/en/user-guide/querying-cancel-statements The recommended way to cancel a statement is to use the interface of the application in which the query is running (e.g. the Worksheet in the Snowflake web interface) or the cancellation API provided by the Snowflake ODBC or JDBC driver. However, in some cases, it is necessary to cancel a query using SQL. Snowflake provides the following functions to support using SQL to cancel running/active statements: SYSTEM$CANCEL_ALL_QUERIES SYSTEM$CANCEL_QUERY I say B.
upvoted 1 times
...
DerfelCardarn
4 weeks ago
Selected Answer: B
"From other worksheet". Go to the worksheet with the long running query and clic abort.
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago