SnowPro Core Certification — Question 1278

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?

Answer options

• 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.

Correct answer: B

Explanation

The fastest way to cancel the long-running query is to return to the worksheet and abort it directly, which can be done immediately. Suspending the virtual warehouse or adjusting its properties could impact other queries and take more time, while finding and canceling the query in the activity view may also take longer than aborting it from the worksheet.