DEA-C02 Question #115: Real Exam Question with Answer & Explanation

Question

A table was created under MY_SCHEMA: CREATE TABLE my_schema.orders ( order_id INT, order_item_nr INT ) DATA_RETENTION_TIME_IN_DAYS = 5; The DATA_RETENTION_TIME_IN_DAYS value on the schema is reset to = 10. Then a new table is created under MY_SCHEMA: CREATE TABLE my_schema.final( final_order_id INT, final_order_item_nr INT); What will happen if the Time Travel DATA_RETENTION_TIME_IN_DAYS value at the schema level is changed from = 10 to = 20?

Options

• AThe DATA_RETENTION_TIME_IN_DAYS cannot be set at the schema level, so the command will
• BThe DATA_RETENTION_TIME_IN_DAYS on the orders table will not change, but on the final
• CThe DATA_RETENTION_TIME_IN_DAYS will be set at = 20 for both the orders table and the
• DThe DATA_RETENTION_TIME_IN_DAYS will remain the same for both the orders table and the