QuestionQ33Verified/Performance, Cost, and Resource OptimizationCopy linkReport a problemAsk AstroTutorSave questionWhich of the following are characteristics of result set caches?Choose threeATime Travel queries can be executed against the result set cache.BSnowflake persists the data results for 24 hours.CEach time persisted results for a query are used, a 24-hour retention period is reset.DThe data stored in the result cache will contribute to storage costs.EThe retention period can be reset for a maximum of 31 days.FThe result set cache is not shared between warehouses.Show AnswerAnswerExplanationSnowflake persists query results for 24 hours. Whenever a persisted result is reused, its 24-hour retention period is reset, up to a maximum of 31 days from the original execution time.Learn moreUsing Persisted Query ResultsShow comments3Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion