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 deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
A deterministic query will return precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period. Additionally, the 24-hour timer for the precomputed results is renewed every time the exact query is executed.
correct answer is B, D
BD for sure
BD Explanation for D is here https://docs.snowflake.com/en/user-guide/querying-persisted-results.html
BD is the correct answer
option B, D
correct answer is B, D
Answer is B,D.
answer BD
B and D are correct
The results cache will only be used if it's the same query AND the same role executing the query
Obviously it is B,D by MinuteMaid
BD are correct
correct answer is B, D
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.
esas son las correctas b y d
B and D are correct
B and D