COF-C03: SnowPro Core Certification

Question

A report runs against a table every 8 hours. New data is loaded into the table every 30 days. The query executed immediately after the most recent data load took 5 minutes to finish, whereas the following several executions finished in under 30 seconds.

When will query execution start to slow down?

Explanation

Persisted query-result reuse is available only while the contributing table data has not changed. Running the same query every 8 hours refreshes its 24-hour retention period, but the next data load changes the table after 30 days and prevents reuse of the prior result. The subsequent execution must regenerate the result and is slower.

Learn more

Using Persisted Query Results

COF-C03: SnowPro Core Certification

AstroTutor

Notes

Readiness

QuestionQ108

Community Discussion