Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
