SnowPro Core Certification — Question 565

What is required for a query execution to be served from the result cache?

Answer options

• A. The user is the same.
• B. The SQL texts the same.
• C. The SQL query profile is the same.
• D. The virtual warehouse is the same.

Correct answer: B

Explanation

For a query to be served from the result cache, the SQL texts must be the same, as this ensures that the cached results correspond to the exact query being executed. Other factors like the user, SQL query profile, or virtual warehouse can differ but do not impact the ability to retrieve results from the cache.