Answer: 24 hours

The correct answer is D (24 hours) based on Snowflake documentation and community consensus. Snowflake's Result Cache stores query results for 24 hours after the last access, provided the underlying data hasn't changed. This is confirmed by the community discussion where all comments unanimously select D, with one comment specifically quoting Snowflake documentation: 'Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed.' The other options (1 hour, 3 hours, 12 hours) are incorrect as they don't match Snowflake's documented 24-hour retention period for the Result Cache.

Author: LeetQuiz Editorial Team