Will data cached in a warehouse be lost when the warehouse is resized?
Will data cached in a warehouse be lost when the warehouse is resized?
When the warehouse is resized to a smaller size, the compute resources associated with the warehouse are reduced, leading to a loss of the cache associated with those resources. This means that cached data may be lost if it no longer fits within the new, smaller warehouse size.
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out. At the "tip" it states: ... which CAN impact performance ... "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."
Based on this explanation, answer is B. YES, cached data is dropped. right?
Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
my bad : 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. so means possibly yes if it got reducerd so A is correct https://docs.snowflake.com/en/user-guide/warehouses-considerations
possibly B
A is correct, only catch dropped if warehouse size is decreased.
A Is correct answer
Correct Answer: A
B. Yes, because the compute resource is replaced in its entirety with a new compute resource. When a Snowflake warehouse is resized, the current compute resources are replaced with new ones. This process clears the existing cache, and thus the cached data will be lost during the resizing operation.
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. Keep this in mind when choosing whether to decrease the size of a running warehouse or keep it at the current size. In other words, there is a trade-off with regards to saving credits versus maintaining the cache.
A is correct
Answer is A 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.
new compute resources will no longer have the data cache from old compute resources.
https://www.bing.com/search?q=Will+data+cached+in+a+warehouse+be+lost+when+the+warehouse+is+resized%3F%0D%0A&qs=n&form=QBRE&sp=-1&lq=1&pq=will+data+cached+in+a+warehouse+be+lost+when+the+warehouse+is+resized%3F&sc=1-71&sk=&cvid=EF9EDA8E014D4727A39525F970AE710F&ghsh=0&ghacc=0&ghpl=
i believe C is correct @
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. Keep this in mind when choosing whether to decrease the size of a running warehouse or keep it at the current size. In other words, there is a trade-off with regards to saving credits versus maintaining the cache.
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html When the warehouse shrink it impacts