Snowpro Core · Free Practice Question Easy

Question 30

How long do results remain in the Query results cache?
  • A 1 hours
  • B 31 hours
  • C 24 hours
  • D 16 hours
  • E 12 hours
Reveal correct answer

Correct answer: C

Explanation

Results are retained for 24 hours in Query Result Cache. Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed. After 31 days, the result is purged and the next time the query is submitted, a new result is generated and persisted.

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need