SnowPro Core Certification — Question 234

Which cache type is used to cache data output from SQL queries?

Answer options

• A. Metadata cache
• B. Result cache
• C. Remote cache
• D. Local file cache

Correct answer: B

Explanation

The Result cache is specifically designed to store the results of SQL queries, which speeds up response times for repeated queries. The other options, such as Metadata cache, Remote cache, and Local file cache, serve different purposes and do not directly cache SQL query outputs.