Which of the following conditions must be met in order to return results from the results cache? (Choose two.)
Which of the following conditions must be met in order to return results from the results cache? (Choose two.)
To return results from the results cache, the user must have the appropriate privileges on the objects associated with the query, ensuring that they are authorized to access the cached data. Additionally, the query must be run within 24 hours of the previously-run query, as the caching mechanism typically has a time limit to ensure the relevance and freshness of the cached results.
A&E as the below link: https://docs.snowflake.com/en/user-guide/querying-persisted-results.html#retrieval-optimization
E is correct and maybe A If the same query is fired again in 24 hrs, it will not be COMPUTED, which means it will not be charged. and it is not affected by WH suspension. So as the previous question the same exact query will return the pre-computed results if the underlying data hasn't changed and the results were last accessed within previous 24-hour period
A&E are the conditions
Answer -- A&E
AE are correct
C&E having access on an object might not give the same results... need to revisit the answer ..
A and E correct
correct
The user has the appropriate privileges on the objects associated with the query. The query has been run within 24 hours of the previously-run query.
how about C and E ?
it doesn't matter with the warehouse since the result cache returning is through cloud service layer.
Answer -- A&E