A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schema. One of the requirements is to have online recovery of data on a rolling 7-day basis.
After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day.
What would cause this to occur? (Choose two.)
The likely causes for the tables remaining unrecoverable past 1 day are: The DATA_RETENTION_TIME_IN_DAYS for the staging schema being set to 1 day and the staging tables being of the TRANSIENT type. The DATA_RETENTION_TIME_IN_DAYS setting at the schema level overrides the database level setting. Additionally, TRANSIENT tables do not retain data for time travel, which means they do not support data recovery for any period.
Answer is B,D and is validated
Answer seems correct B & D
Changing answer to A & B