Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1109

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

Create transient tables and periodically copy them to permanent tables.

Create temporary tables and periodically copy them to permanent tables.

Create regular tables with extended Time Travel and Fail-safe settings.

Create regular tables with default Time Travel and Fail-safe settings.

Correct Answer: A

To minimize Continuous Data Protection costs when dealing with large, high-churn dimension tables, one effective approach is to create transient tables and periodically copy the data to permanent tables. Transient tables do not retain Time Travel data, which reduces storage costs associated with data retention, making it a cost-efficient solution.

Discussion

AnblicksOption: A

For large, high-churn dimension tables that incur overly-excessive CDP costs, the solution is to create these tables as transient with zero Time Travel retention (i.e. DATA_RETENTION_TIME_IN_DAYS=0) and then copy these tables on a periodic basis into a permanent table.

YioukOption: A

https://docs.snowflake.com/en/user-guide/tables-storage-considerations