Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 76

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

    Correct Answer: B, C

    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
arpit_dataguyOptions: BC

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

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

AmitsnowflakeOptions: BC

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.

Mallikharjuna452Options: BC

B and C are correct

Mayuri917233Options: BC

BC correct

Tapasgup007Options: BC

BC are correct