Notifications
Clear all
Topic starter
A deterministic query is run at 8am, takes 5 minutes, and the results are cached.
Which of the following statements are true? Choose 2 answers
- A . The exact query win ALWAYS return me 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 the 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
D. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
Suggested Answer: B,D
Explanation:
The results cache will only be used if it's the same query AND the same role executing the query
Explanation:
The results cache will only be used if it's the same query AND the same role executing the query
Posted : 06/11/2022 10:37 pm