DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ12

VerifiedOfficial exam objectives/topics

A Data Engineer has created a dashboard that sends the identical SQL SELECT clause to Snowflake every 12 hours.

Provided the underlying data remains unchanged, for how long will Snowflake use persisted query results from the result cache?

Explanation

Snowflake persisted query results expire after 24 hours. Reusing an identical eligible query resets the 24-hour retention period, up to a maximum of 31 days from the initial execution; the normal cache period applicable to each 12-hour run is therefore 24 hours.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!