
Answer-first summary for fast verification
Answer: Disaster recovery, Database failover and failback
The question asks for two benefits of Snowflake's replication feature. Based on the community discussion and Snowflake documentation, the primary benefits are disaster recovery (A) and database failover/failback (D). Disaster recovery ensures business continuity by maintaining data copies in different regions, while database failover/failback enables seamless switching between primary and secondary databases during outages. Option B (Time Travel) is a separate Snowflake feature for data recovery within a time window, not directly related to replication. Option C (Fail-safe) is a data protection mechanism for accidental deletions, not a replication benefit. Option E (Data security) is incorrect as replication increases risk exposure by distributing data across locations, and while the linked comment suggests E might be correct, the consensus and higher upvotes support A and D as the optimal answers for business continuity purposes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.