Exam SnowPro Core topic 1 question 198 discussion

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

answer correct is 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.

C. If the referenced data in the table has changed

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

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.

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

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

Correct

C is correct

C is the correct answer

C is the correct answer

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

C is correct agree

agree C is the right answer

C appears correct

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.