Answer: Result cache

The question asks which cache type is used to store the result set of a query. In Snowflake, the Result Cache (option B) specifically stores the results of queries executed in the past 24 hours, making them available across virtual warehouses for reuse when the same query is executed again, provided the underlying data hasn't changed. This directly matches the question's focus on caching 'data output from SQL queries.' The community discussion strongly supports this, with 80% selecting B and the top-voted comment (11 upvotes) clearly explaining the Result Cache's purpose. Option D (Local file cache) is incorrect as it caches data used by queries (from Remote Disk storage) for performance, not the query results themselves. Options A and C are not relevant to storing query result sets.

Author: LeetQuiz Editorial Team