COF-C03 - Data Collaboration - Section 5.4

Describe database and account replication and failover and failback for business continuity and disaster recovery.

Describe how Snowflake replicates data and objects across accounts and regions for business continuity: database and account replication to keep a secondary in sync, and failover and failback to promote a secondary during an outage and return afterwards. Recognise replication groups and that replication supports both disaster recovery and bringing data closer to users.

database replicationaccount replicationfailover and failbackreplication groupsbusiness continuity

Practice question for this objective

Free sampleData Collaborationmedium

An organisation runs its production account in one region and wants a disaster recovery account in a second region that can take over the business if the primary region fails. The recovery must bring across not just table data but also the account-level objects such as users, roles, warehouses and resource monitors, and it must be possible to promote the secondary so it serves writes during an outage. Which Snowflake capability best meets this requirement?

  • AA failover group that replicates the chosen databases together with account objects such as users, roles, warehouses and resource monitors to the second account, and can be failed over to promote the secondary as primary Correct
  • BA secure data share of every production database to the second account, so the recovery account reads live production data and is promoted to accept writes when the primary region is unavailable
  • CDatabase replication configured separately on each production database, which copies the table data to the second account and lets each replicated database be promoted independently to accept writes during the outage
  • DA zero-copy clone of each production database created in the second account, which provides an instant independent copy that the recovery account can write to as soon as the primary region goes down
Recognise that a failover group replicates databases together with account objects across regions and can be promoted, providing coordinated account-level disaster recovery. A failover group is a defined collection of databases and account objects, including users, roles, warehouses, resource monitors and policies, that Snowflake replicates as one consistent unit to a target account in another region or cloud. Because the group supports failover, the secondary can be promoted to primary and begin serving writes during an outage. Plain database replication moves only database objects, and sharing or cloning cannot promote a remote account to take over production.

Why A is correct: A failover group replicates selected databases plus account-level objects as one consistent unit and supports failover, so the secondary account can be promoted to primary and serve writes during a regional outage, exactly as required.

Why B is wrong: Secure data sharing gives read-only access to live data and shares only databases, not account objects like users and roles, and a share cannot be promoted to serve writes, so it does not provide failover.

Why C is wrong: Database replication copies database objects but not account-level objects such as users, roles and warehouses, and promoting many databases one by one is not a coordinated account failover, so it falls short of the requirement.

Why D is wrong: Zero-copy cloning operates within a single account and region and creates a point-in-time copy, not an ongoing cross-region replica, so it cannot keep a remote recovery account current or fail over to it.

See more COF-C03 practice questions, answers explained.

More in this domain

Back to all Data Collaboration objectives, or the COF-C03 cert hub.

Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.