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.
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.
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.
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.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
arpit_dataguy
Highly Voted 2 years, 9 months agoABRocks
Most Recent 3 months agoVLMBL_94
3 months, 1 week agovivekmani2021
3 months, 2 weeks agoMallikharjuna452
4 months agopranalig
5 months agoAnireddySaikiranReddy
8 months, 3 weeks ago_yyukta
8 months, 4 weeks agoJules27
10 months agoRajivnb
1 year, 4 months agoLeinho
1 year, 5 months agoSravantiJana
1 year, 5 months agofahfouhi94
1 year, 9 months agosystematics78
1 year, 9 months agoYokoSumiGaeshi
1 year, 9 months agosubbie
1 year, 10 months agoSV1122
1 year, 10 months agoSV1122
1 year, 10 months ago