Answer: Create transient tables and periodically copy them to permanent tables.

The question asks how to minimize Continuous Data Protection (CDP) costs for large, high-churn dimension tables. CDP costs in Snowflake are primarily driven by Time Travel and Fail-safe storage. Transient tables (option A) do not have Fail-safe and can have Time Travel disabled (DATA_RETENTION_TIME_IN_DAYS=0), significantly reducing CDP costs compared to regular tables. Periodically copying transient tables to permanent tables preserves data without incurring continuous high CDP costs. Option B (temporary tables) is incorrect as they are session-scoped and not suitable for persistent dimension tables. Option C (regular tables with extended Time Travel/Fail-safe) would increase, not minimize, CDP costs. Option D (regular tables with default settings) still incurs standard CDP costs, which are higher than transient tables with zero retention. The community discussion strongly supports A, with upvoted comments explaining that transient tables avoid Fail-safe costs and can have zero Time Travel retention.

Author: LeetQuiz Editorial Team