COF-C02 Question 224

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose B2

  When you resize a warehouse (scale up or down), the cache is dropped because the warehouse is rebuilt with new compute resources.

• Chose B3

  https://docs.snowflake.com/en/user-guide/warehouses-considerations Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed.

• 1

  A Is correct answer