SnowPro Advanced: Architect · Free practice question 6 of 10
Multi-region failover
A production Snowflake account in us-east-1 must have a warm-standby replica in eu-west-1 so the team can fail traffic over within minutes of a regional outage. Which combination of features implements this?
- A.Zero-copy cloning of the databases into the target account.
- B.Time Travel with a 30-day retention window on the source account.
- C.Database replication into the target region combined with a failover group and client redirect (Snowflake connection URL that redirects on failover).
- D.External stages backed by cross-region S3 buckets, with COPY INTO commands on a schedule.
Show answer and explanation
Correct answer: C. Database replication into the target region combined with a failover group and client redirect (Snowflake connection URL that redirects on failover).
Why: Database replication keeps the target account's data in sync; a failover group promotes the standby account to primary on failover; client redirect lets applications keep the same connection URL and be transparently pointed at the new primary. The other options don't provide cross-region warm-standby with fast failover.