SnowPro Advanced: Architect — Question 54

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.)

Answer options

• 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.

Correct answer: B, D

Explanation

The correct answer is B and D because if the DATA_RETENTION_TIME_IN_DAYS for the staging schema is set to 1 day, it limits recovery to that timeframe. Additionally, TRANSIENT tables do not support recovery beyond a single day, which explains the unrecoverable state. Options A, C, and E do not directly relate to the specified recovery limitations.