Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
When working with dimension tables that change frequently, what is the recommended approach for managing costs?
A
Keep the Time Travel retention period for the dimension tables to 7 days or less.
B
Make the dimension tables transient with a retention period of 0 days, and backup the table daily to a permanent table. Delete all but the latest backup.
C
Make the dimension tables transient and back-up the data daily into a permanent table using cloning.
D
Make the dimension tables permanent with a retention period of 7 days. Replicate the database to a secondary database once a week.