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 Explanation for D is here https://docs.snowflake.com/en/user-guide/querying-persisted-results.html
BD for sure
BD is the correct answer
B and D
B and D are correct
esas son las correctas b y 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.
correct answer is B, D
BD are correct
Obviously it is B,D by MinuteMaid
The results cache will only be used if it's the same query AND the same role executing the query
B and D are correct
answer BD
Answer is B,D.
correct answer is B, D
option B, D