ARA-C01 · Question #21
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 hav
The correct answer is B. The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day. D. The staging tables are of the TRANSIENT type.. Snowflake's Time Travel data retention follows a hierarchy where a lower-level setting overrides a higher-level one. (B) If the staging schema's DATA_RETENTION_TIME_IN_DAYS is explicitly set to 1 day, that schema-level setting overrides the 7-day database-level setting for all ta
Question
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.)
Options
- AThe staging schema has not been setup for MANAGED ACCESS.
- BThe DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.
- CThe tables exceed the 1 TB limit for data recovery.
- DThe staging tables are of the TRANSIENT type.
- EThe DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.
How the community answered
(42 responses)- A17% (7)
- B74% (31)
- C7% (3)
- E2% (1)
Explanation
Snowflake's Time Travel data retention follows a hierarchy where a lower-level setting overrides a higher-level one. (B) If the staging schema's DATA_RETENTION_TIME_IN_DAYS is explicitly set to 1 day, that schema-level setting overrides the 7-day database-level setting for all tables within it. (D) TRANSIENT tables in Snowflake have a maximum DATA_RETENTION_TIME_IN_DAYS of 1 day (can only be 0 or 1), regardless of what is set at the database or schema level. Option A (MANAGED ACCESS) controls privilege management, not retention. Option C is incorrect-there is no 1 TB size limit for Time Travel. Option E is fabricated; no such ALLOW_RECOVERY privilege exists in Snowflake.
Topics
Community Discussion
No community discussion yet for this question.