True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
It is possible for a user to run a query against the query result cache without requiring an active Warehouse. The query result cache in Snowflake retrieves the results of previously executed queries within a certain time frame, even if the warehouse is suspended. This allows users to fetch data from the cache without needing to restart the warehouse, thereby saving resources.
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.
Result Cache: Service layers. Any query word by word will leverage the result cache within 24 Hrs.
The correct answer is A, and this is based on actual testing this in Snowflake.
Answer: A. This question was answered in Snowflake community forums here https://community.snowflake.com/s/question/0D50Z000088fREuSAM/does-the-query-results-cache-stays-in-cache-after-the-warehouse-is-suspended
Its true
A is not true. The SELECT statement requires warehouse. The result set can be retrieved if data is not changed, not use some functions and etc.. but in any case, you can't use a select statement without a warehouse
I upvoted this because it intuitively makes sense. But then I tested it in Snowflake and I was able to retrieve a result from the result cache using a SELECT while using a suspended warehouse (without auto resume). So A is indeed the correct answer.
True, you can
Query results are cached for 24hours and is not dependent on warehouse being up or down
the correct answer is A , daba can be no changed last 24h so possible
A query can use the query result cache but can not query from it.
You cannot run a query against cache, if you run the exact same query that some else previously ran, snowflake has the capability to retrieve the result from cache without running a warehouse, but non user can see others users query results.
The answer is B. Question is not about can a user query utilize the data from cache. Its about running query against a stored query result cahce. That is not possible. User has no option to do anything with cached results.
The answer is B - False - https://docs.snowflake.com/en/user-guide/performance-query-warehouse-cache?utm_source=snowscope&utm_medium=serp&utm_term=query+cache The auto-suspension setting of the warehouse can have a direct impact on query performance because the cache is dropped when the warehouse is suspended.
A. True
Correct Answer: A
False is correct without selection of warehouse an query cannot be executed
A.True