A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose 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
B -Snowflake's result cache will return the precomputed results if the data has not changed and the cached results are still valid (within 24 hours of the last access).
D- Every time the query is executed, the 24-hour timer for the cached results is reset, extending the validity of the cached results.
BD I think, but bad wording on B: "previous" 24 hours would mean before the original query was run, so taken literally this is incorrect but I think they mean the next 24 hours.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ggww
Highly Voted 3 years, 4 months ago4762448
Most Recent 1 month agoBrunoRYamada
1 month, 1 week agoSudhansu21
2 months, 2 weeks agoMallikharjuna452
9 months, 3 weeks ago_yyukta
1 year, 2 months ago444823b
1 year, 4 months agorich922
1 year, 11 months agoMayuri917233
1 year, 12 months agoSV1122
2 years, 4 months agoTapasgup007
2 years, 5 months agoGraghu
2 years, 12 months agoSly007
3 years agoMinuteMaid
3 years, 1 month agoFosterchild123
3 years, 2 months agoAnirudh2020
3 years, 2 months agoRajokkiyam
3 years, 3 months ago