SnowPro Core Certification — Question 1177

Where does Snowflake store the data output from a query that was executed in the past 24 hours?

Answer options

• A. In a micro-partition
• B. In a remote disk
• C. In the result cache layer
• D. In the local disk cache layer

Correct answer: C

Explanation

The results of queries executed in the past 24 hours are stored in the result cache layer, allowing for quick retrieval if the same query is run again. The other options, such as remote disk and local disk cache layer, do not specifically handle the storage of query results in the same manner as the result cache layer.