ExamGecko
Question list
Search
Search

Question 632 - COF-C02 discussion

Report
Export

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

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

Explanation:

To minimize Continuous Data Protection (CDP) costs when dealing with large, high-churn dimension tables in Snowflake, using transient tables is a recommended approach.

Transient Tables: These are designed for data that does not require fail-safe protection. They provide the benefit of reducing costs associated with continuous data protection since they do not have the seven-day Fail-safe period that is mandatory for permanent tables.

Periodic Copying to Permanent Tables: By periodically copying data from transient tables to permanent tables, you can achieve a balance between data protection and cost-efficiency. Permanent tables offer the extended data protection features, including Time Travel and Fail-safe, but these features can be applied selectively rather than continuously, reducing the overall CDP costs.

References:

Snowflake Documentation on Transient Tables

Snowflake Documentation on Time Travel & Fail-safe

asked 23/09/2024
brandon millette
50 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first