Which statement about fail-safe data in a Snowflake secondary database is true?

• A. It is replicated to all secondary databases
• B. It is maintained independently for each secondary and not replicated from primary
• C. It is stored only for the primary database
• D. It is deleted after 7 days

Answer: (B)

Fail-safe is a Snowflake-managed protection layer that kicks in after the Time Travel window to provide data recoverability. In a replication setup, each database—the primary and every secondary—has its own fail-safe data that Snowflake maintains. It’s not copied from the primary to the secondaries. So, fail-safe data for each secondary is kept independently, which is why that statement is true. The other ideas don’t fit because fail-safe isn’t replicated across secondaries and it isn’t shared from the primary; each database has its own fail-safe window and recovery behavior.