certifhub logo
Use code BLOG30 | 30% OFF
Copied! Paste at checkout

Snowpro Core · Free Practice Question Medium

Question 42

You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. The query run by the dashboard user never changes. How will Snowflake manage changing and non-changing data? Mark all true statements.
  • A

      Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available.  

  • B

    Snowflake will spin up a warehouse only if the underlying data has changed.
  • C Snowflake will show the most up-to-date data each time the dashboard is refreshed.
  • D

    Snowflake will compile result cache data from all user results, so no warehouse is needed.
Reveal correct answers

Correct answers: A, B, C

Explanation

Until data has not changed and the query is the same - Snowflake reuses the data from the cache. Please note,  Each time the persisted result for a query is reused, 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