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.
Your response doesn't actually answer the question. Yes if the wh has been suspended and the cache is dropped, sure, the cache is no longer available for re-use. but the answer to the question is A: True.
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.
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 3 years, 2 months agobor4un
Most Recent 2 months, 3 weeks agoABRocks
8 months agoVLMBL_94
8 months, 2 weeks agovivekmani2021
8 months, 3 weeks agoMallikharjuna452
9 months agopranalig
10 months, 1 week agoAnireddySaikiranReddy
1 year, 1 month ago_yyukta
1 year, 1 month agoJules27
1 year, 2 months ago56d43d6
3 months, 3 weeks agoRajivnb
1 year, 9 months agoLeinho
1 year, 10 months agoSravantiJana
1 year, 10 months agofahfouhi94
2 years, 2 months agosystematics78
2 years, 2 months agoYokoSumiGaeshi
2 years, 2 months agosubbie
2 years, 3 months agoSV1122
2 years, 3 months ago