Final answer:
The correct statements about Snowflake Failsafe are: Snowflake Failsafe provides 90 days of historical data protection for permanent tables, protects data in case of catastrophic failure, and is separate from the Time Travel feature. (option A, C & D)
Step-by-step explanation:
Selecting all that is true about Snowflake Failsafe:
Failsafe provides up to 90 days of historical data protection for permanent tables.
Failsafe indeed provides up to 90 days of historical data protection for permanent tables. This duration allows users to recover data lost due to various events, providing a comprehensive data protection mechanism.
Failsafe is designed to ensure historical data protection in the case of catastrophic failures, such as hardware failures or data center outages. It acts as a safeguard against the loss of critical data in such scenarios.
Failsafe ensures historical data is protected in the event of a catastrophic failure.
Failsafe is distinct and separate from the Time Travel feature.
Failsafe is indeed distinct and separate from the time travel feature. While time travel allows users to query historical data within a defined time window, Failsafe focuses on providing a longer-term protection mechanism for historical data, ensuring data durability.
To clarify, Failsafe is a feature of Snowflake that provides extended protection beyond Time Travel capabilities. While Time Travel allows users to access historical data within a defined period, typically up to 0 to 90 days depending on the Snowflake edition, Failsafe adds a layer of protection. After the Time Travel retention period ends, Failsafe maintains the data for another seven days to protect against data loss in the event of a catastrophic system failure. It's important to note that during the Failsafe period, the data is not directly accessible to users, but Snowflake can use it for data recovery purposes.