ADA-C01 Question #83: Real Exam Question with Answer & Explanation

Question

Options

• ARelated data should not be placed together in the same schema. Facts and dimension tables
• BThe fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.
• CThe DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for
• DOnly TRANSIENT tables should be used to ensure referential integrity between the fact and
• EThe fact and dimension tables should be cloned together using the same Time Travel options to

Explanation

According to the Understanding & Using Time Travel documentation, Time Travel is a feature that allows you to query, clone, and restore historical data in tables, schemas, and databases for up to 90 days. To meet the requirements of the scenario, the following best practices should be - The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS. This parameter specifies the number of days for which the historical data is preserved and can be accessed by Time Travel. To ensure that the fact and dimension tables can be reverted to a consistent state in case of any anomalies in the latest load, they should have the same retention period. Otherwise, some tables may lose their historical data before others, resulting in data inconsistency and quality issues. - The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data. Cloning is a way of creating a copy of an object (table, schema, or database) at a specific point in time using Time Travel. To ensure that the fact and dimension tables are cloned with the same data set, they should be cloned together using the same AT or BEFORE clause. This will avoid any referential integrity issues that may arise from cloning tables at different points in time.

No community discussion yet for this question.