Regarding query result retention, using a query result resets the 24-hour retention window, and results are retained for up to 31 days from the first execution.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Regarding query result retention, using a query result resets the 24-hour retention window, and results are retained for up to 31 days from the first execution.

Explanation:
Query results are kept for a default 24-hour window to support quick reuse. If you actively use that result—open it or feed it into another query—the 24-hour clock for that result is reset. Yet there’s an overall ceiling: the results can be retained for up to 31 days from the very first execution. So you can access the results for up to 31 days, even if you reuse them within that period; after that, they’re purged. For example, a query run on day 0 can be used again up to day 31, with the 24-hour clock restarting when you reuse it, but it won’t extend beyond the 31-day cap.

Query results are kept for a default 24-hour window to support quick reuse. If you actively use that result—open it or feed it into another query—the 24-hour clock for that result is reset. Yet there’s an overall ceiling: the results can be retained for up to 31 days from the very first execution. So you can access the results for up to 31 days, even if you reuse them within that period; after that, they’re purged. For example, a query run on day 0 can be used again up to day 31, with the 24-hour clock restarting when you reuse it, but it won’t extend beyond the 31-day cap.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy