COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ48

VerifiedAccount Management & Data Governance

A user manages a database containing several large tables that are updated frequently. They notice increasing storage costs, primarily from Continuous Data Protection (CDP) features.

To lower storage costs while retaining data protection, which table type should they select?

Explanation

Transient tables persist beyond individual sessions while avoiding the Fail-safe period and limiting Time Travel retention, which reduces CDP-related storage costs. For large, high-churn tables, Snowflake recommends transient tables with periodic copies to permanent tables to preserve recoverability through protected backups.

Learn more

Community Discussion

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