SnowPro Core Certification — Question 326

What affects whether the query results cache can be used?

Answer options

• A. If the query contains a deterministic function
• B. If the virtual warehouse has been suspended
• C. If the referenced data in the table has changed
• D. If multiple users are using the same virtual warehouse

Correct answer: C

Explanation

The correct answer is C, as the query results cache cannot be utilized if the referenced data in the table has changed, rendering previous results invalid. Options A, B, and D do not directly impact the cache's usability; for instance, a deterministic function does not prevent cache usage, and a suspended warehouse affects availability rather than cache functionality.