SnowPro Advanced: Data Engineer — Question 9

A Data Engineer has developed a dashboard that will issue the same SQL select clause to Snowflake every 12 hours.
How long will Snowflake use the persisted query results from the result cache, provided that the underlying data has not changed?

Answer options

• A. 12 hours
• B. 24 hours
• C. 14 days
• D. 31 days

Correct answer: D

Explanation

The correct answer is D, 31 days, as Snowflake retains the result cache for queries whose underlying data has not changed for up to 31 days. Options A, B, and C are incorrect because they underestimate the duration for which Snowflake can cache the results when no data modifications occur.