Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q12: Data in fail-safe can be deleted by
Q13: Which of the following commands are not
Q14: Reader Accounts incur no additional Compute costs
Q15: Query ID's are unique across all Snowflake
Q16: In which layer of its architecture does
Q18: Fail-safe is unavailable on which table types?
Q19: Pipes can be suspended and resumed.
Q20: Micro-partition metadata enables some operations to be
Q21: Which item in the Data Warehouse migration
Q22: Which of the following statements are true