🔥 3-day streak
Snowflake SnowPro Core (COF-C03)93 / 148
Question 93 of 148
A BI dashboard runs the exact same aggregation query against the SALES table every few minutes for hundreds of analysts. You confirm the query is deterministic and does not use non-deterministic functions. Yesterday the query consistently reused the result cache and returned in under a second. This morning, every execution is scanning micro-partitions and running on the warehouse again, even though the query text is byte-for-byte identical. What is the MOST likely reason the result cache is no longer being used?
Reviewed for accuracy · Report an issueNext question