Exam SnowPro Core topic 1 question 629 discussion

B Correct: When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running. https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour

This article says: https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running. However, like another user isolated_sniper said, it continued executing. I submitted a query, ended the session, came back, logged out, logged back in, the query continued executing. So D is correct. B is not correct based on testing. Documentation is not correct /up-to-date.

From a costing point of view it has to cancel otherwise who is paying for the query especially if its no longer required

When a user exits Snowsight during a session where a query is running, Snowflake continues to execute the query in the same session. The query will not be canceled or paused due to the user exiting the interface.

When a user exits Snowsight during a session while a query is running, the query continues to execute in Snowflake independently of the Snowsight interface. Snowflake runs queries on its servers, and Snowsight is simply an interface for interacting with Snowflake's services. Exiting Snowsight does not affect the execution of the query itself. Once a query is submitted to Snowflake, it continues to run until completion, cancellation, or until it reaches a timeout limit, regardless of whether the user remains connected to the Snowsight interface. The user can check the status or results of the query later by reconnecting to Snowsight or by accessing the Snowflake web interface or other client tools. Snowflake also provides options to monitor and manage long-running queries through its web interface or using SQL commands.

I executed a query with snowsight verified th session ID then logged out, when I loged in the previous query continued to execute. I ran another query on the same worsheet, the session ID have changed for the new query but the first query continued to run with the previous session ID

B correct

This is confusing. https://docs.snowflake.com/en/user-guide/session-policies --> Caution Active queries are not canceled when the session ends and the user is logged out, even if the ABORT_DETACHED_QUERY parameter is set to true. https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour --> Important: When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running.

B Important: When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running. https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour

its B i checked it here view and scroll to the end https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour

Should be D

no I tested several times, it continues to run it

Should be B https://docs.snowflake.com/en/user-guide/ui-snowsight-quick-tour#user-menu

None. Snowflake will continue to execute on the virtual warehouse assigned to the session even after user has logged out.