When is the result set cache no longer available? (Choose two.)
When is the result set cache no longer available? (Choose two.)
The result set cache is no longer available when the underlying data has changed and when it has been 24 hours since the last query. This is because any change in the underlying data invalidates the cached result, and the cached results are only maintained for 24 hours.
C and E
C and E https://docs.snowflake.com/en/user-guide/querying-persisted-results
C,E is correct
C and E are correct
Isn't D also an answer, along with C & E
Warehouse may not be needed to read data available in cache, hence data would still be available for the read
C and E
C and E
C AND E are correct
C and E are correct answers
Using Persisted Query Results Snowflake uses persisted query results to avoid re-generating results when nothing has changed For persisted query results of all sizes, the cache expires after 24 hours.
C,E is correct
C and E
TWO RESPONSES: - undelying data not changes - 24h
C and E
CE Correct
CE is correct
C & E correct, if the use_cached_result is set to extended period.
C and E Query result persist only for 24 hours.
C and E
C and E
C and E. I'm trying to make both voting 50% each
C. When the underlying data has changed
C and E
C and E are correct answers
C + E are both correct