SnowPro Core Certification — Question 1265

When working with dimension tables that change frequently, what is the recommended way to manage costs?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because making dimension tables transient with a 0-day retention helps to minimize costs associated with storage, while daily backups ensure that the latest data is preserved. Options A, C, and D do not effectively address cost management for frequently changing data, as they either maintain unnecessary data retention or do not implement a sufficient backup strategy.