SnowPro Core Certification — Question 1072

How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

Answer options

• A. Create transient tables and periodically copy them to permanent tables.
• B. Create temporary tables and periodically copy them to permanent tables.
• C. Create regular tables with extended Time Travel and Fail-safe settings.
• D. Create regular tables with default Time Travel and Fail-safe settings.

Correct answer: A

Explanation

The correct answer is A because transient tables are not stored permanently and thus incur lower costs in a Continuous Data Protection setup. Options B, C, and D involve either temporary or regular tables, which do not provide the same cost-saving benefits as transient tables, especially when dealing with high-churn data.