SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 76


When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)

Show Answer
Correct Answer: BC

Disabling auto-suspend for a Virtual Warehouse is appropriate when managing a steady workload, as the warehouse needs to be available consistently to handle the demand without interruption. Additionally, auto-suspend should be disabled when the compute must be available with no delay or lag time, ensuring that operations can proceed without waiting for the warehouse to resume.

Discussion

5 comments
Sign in to comment
arpit_dataguyOptions: BC
Jan 18, 2022

From snowflake documentation : You might want to consider disabling auto-suspend for a warehouse if: You have a heavy, steady workload for the warehouse. You require the warehouse to be available with no delay or lag time. Warehouse provisioning is generally very fast (e.g. 1 or 2 seconds); however, depending on the size of the warehouse and the availability of compute resources to provision, it can take longer.

LautaroBarone
May 9, 2023

Source: https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension

AmitsnowflakeOptions: BC
Aug 22, 2023

You might want to consider disabling auto-suspend for a warehouse if: You have a heavy, steady workload for the warehouse. You require the warehouse to be available with no delay or lag time.

Tapasgup007Options: BC
Dec 8, 2022

BC are correct

Mayuri917233Options: BC
May 11, 2023

BC correct

Mallikharjuna452Options: BC
Jul 18, 2024

B and C are correct