Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A deterministic query is executed at 8:00 AM, takes 5 minutes to run, and its results are cached. Which of the following statements are true? (Select two.)
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