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…

Question

Options

• A12 hours
• B24 hours
• C14 days
• D31 days

• A
  2% (1)
• B
  6% (3)
• C
  2% (1)
• D
  90% (46)

Explanation

Snowflake's result cache stores query results for 24 hours after each execution, but resets the 24-hour timer every time the same query runs against unchanged data. Since the dashboard runs every 12 hours (within the 24-hour window), the cache keeps refreshing indefinitely - up to a hard maximum of 31 days, which is Snowflake's absolute limit for persisted query results.

Why the distractors are wrong:

• A (12 hours) is simply the query execution interval, not a cache duration limit - it's a distractor drawn from the scenario itself.
• B (24 hours) is the initial cache window - how long results last if the query is never rerun - but because the query runs every 12 hours, the timer keeps resetting well past 24 hours.
• C (14 days) has no basis in Snowflake's result cache documentation; it's a plausible-sounding middle ground designed to trap guessers.

Memory tip: Think "31 days = one month max." Snowflake's result cache is generous - it rewards frequently repeated queries on stable data by caching up to a full month, as long as you keep hitting it within each 24-hour window.

No community discussion yet for this question.