What would cause this to occur?

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.)
A . The staging schema has not been setup for MANAGED ACCESS.
B. The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.
C. The tables exceed the 1 TB limit for data recovery.
D. The staging tables are of the TRANSIENT type.
E. The DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.

View Answer

Answer: B,D