What are the benefits of the replication feature in Snowflake? (Select TWO).

The correct answer is A. Disaster recovery D. Database failover and fallback. Snowflake's database replication feature synchronizes databases across different regions or cloud providers (e.g., AWS us-east-1 to Azure eastus). Its primary benefits are: (1) Disaster Recovery - if the primary region becomes unavailable, the replicated database in another…

Data Protection and Data Sharing

Question

Options

ADisaster recovery
BTime Travel
CFail-safe
DDatabase failover and fallback
EData security

How the community answered

(23 responses)

A
87% (20)
B
9% (2)
E
4% (1)

Explanation

Snowflake's database replication feature synchronizes databases across different regions or cloud providers (e.g., AWS us-east-1 to Azure eastus). Its primary benefits are: (1) Disaster Recovery - if the primary region becomes unavailable, the replicated database in another region can be promoted to serve traffic; and (2) Database Failover and Fallback - a connection failover group allows automatic or manual redirection of client connections to a secondary replica, and fallback returns connections to the original primary once it's restored. Time Travel and Fail-safe are independent Snowflake data protection features unrelated to replication. Data security is a general capability, not a specific benefit of the replication feature.

Topics

#Replication#Disaster Recovery#Database Failover#Business Continuity

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice