SnowPro Core Certification — Question 611

What happens when a user exits Snowsight during a session that a query is running?

Answer options

• A. Snowflake executes the query during the same session immediately.
• B. Snowflake cancels any queries submitted during this session that are still running.
• C. Snowflake will cancel any queries submitted during this session after 24 hours.
• D. Snowflake will continue to execute and complete upon the next login.

Correct answer: D

Explanation

The correct answer is D because Snowflake allows the query to continue executing even if the user exits Snowsight, and it will complete once the user logs back in. Option A is incorrect as the query does not execute immediately upon exiting. Option B is wrong because Snowflake does not cancel ongoing queries when a user exits. Option C is also incorrect since there is no 24-hour cancellation policy for running queries.