SnowPro Core Certification — Question 4

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

Answer options

• A. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
• B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
• C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
• D. The ג€24 hourג€ timer on the precomputed results gets renewed every time the exact query is executed

Correct answer: B, D

Explanation

Option B is correct because the cached results are valid if the data hasn't changed and were accessed in the last 24 hours. Option D is also correct as executing the same query resets the timer for the cached results. Options A and C are incorrect because A overstates the guarantee of returning cached results, and C incorrectly suggests that changes in the underlying data do not affect the cached results.