Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 198

What affects whether the query results cache can be used?

    Correct Answer: C

    The ability to use the query results cache depends on whether the referenced data in the table has changed. If the data has changed since the last query, the cache cannot be used, and a new query execution is required to retrieve the updated data.

Discussion
SnowProCertDec22Option: C

answer correct is C https://community.snowflake.com/s/article/Understanding-Result-Caching

muks86Option: C

Moderator should update database with correct answers,as in this case it should be C

NaahOption: C

Answer: C Result Cache: Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed.

mighty_kaftaOption: C

C is the correct answer

pranaligOption: C

answer correct is C

PrashantGupta1616Option: C

In Snowflake, the query results cache can be used based on certain conditions. Specifically, whether the referenced data in the table has changed affects the use of the query results cache. If the data has changed since the last query, the cache cannot be used. Therefore, the correct answer is: C. If the referenced data in the table has changed Changes to the underlying data will invalidate the cached results, necessitating a new query execution to retrieve the updated data.

_yyuktaOption: C

C. If the referenced data in the table has changed

Aaron_w_mendelsonOption: C

Results set cache lives in the cloud services layer not the warehouse

BobFarOption: C

Answer is C. A is wrong because non-deterministic function has impact on result cache except current_date Answer B is wrong because : If a virtual warehouse is suspended, it won't be available to execute any queries, so the result cache won't come into play for queries that would have been processed by that warehouse. When a virtual warehouse is resumed after being suspended, any query that benefits from the result cache will continue to do so. The result cache is independent of the state of the virtual warehouse. The result cache is a feature that helps optimize query performance regardless of the state (active or suspended) of the virtual warehouse. Answer D is wrong because same query returns from the cache.

shanksundOption: B

This is 100% B, the Cache is cleared whenever a VW is suspended

Mike722

Only the local disk cache is lost when the VW is suspended. Result Cache is in the service layer and will survive (at least 24 hours) even if all warehouses are suspended.

ThaiyaOption: A

Answer A - if count() sum() or predictable query is used, not C - if data in table is changed the saved answer in cache will become incorrect

Thaiya

My bad, i didnt read question properly. affects then correct answer is C.

MultiCloudIronManOption: C

Correct

bonniezlOption: C

C is correct

n21007Option: C

C is the correct answer

KarBiswaOption: C

C is correct agree

JRayanOption: C

agree C is the right answer

jtm22Option: C

C appears correct