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.
possibly B
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
A is correct, only catch dropped if warehouse size is decreased.
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html When the warehouse shrink it impacts
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.
i believe C is correct @
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=
new compute resources will no longer have the data cache from old compute resources.
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.
A 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.
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.
Correct Answer: A
A Is correct answer