Snowflake DBA

Replication, Failover & Business Continuity

Question

Replication group versus failover group: what differs, and when should each be used?

Answer

A replication group copies a defined object collection to read-only secondary groups. A failover group adds promotion so a secondary can become read-write. Use replication for distributed read access; use failover groups for recovery. Failover requires Business Critical Edition or higher.

This is 13 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples