Answer: In the result cache layer

Snowflake stores query results in the result cache layer for 24 hours after execution. This is a well-documented Snowflake feature where the platform automatically caches the results of every query executed, making them available for subsequent identical queries without re-computation. Option C is correct because the result cache specifically stores query output data. Option A (micro-partition) is incorrect as micro-partitions store raw table data, not query results. Option B (remote disk) is incorrect as this refers to long-term storage, not cached query results. Option D (local disk cache) is incorrect as this refers to caching of frequently accessed table data in virtual warehouse storage, not query results.

Author: LeetQuiz Editorial Team