SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ60

Architecture Overview

A company is developing high-availability and disaster-recovery plans and must maximize redundancy while minimizing recovery time objectives for its critical application processes.

Cost is not a concern provided that the solution is the best available.

The plan currently includes the following steps:

  1. Deploy Snowflake accounts on two separate cloud providers.
  2. Choose cloud-provider regions that are geographically distant from one another.
  3. Replicate the databases and account data between both cloud-provider accounts in the Snowflake deployment.
  4. Implement Snowflake Client Redirect.

What is the MOST cost-effective way to deliver the HIGHEST uptime and the LEAST application disruption in the event of a service event?

Explanation

Snowflake Client Redirect works with account replication to redirect clients to an account in another region or cloud platform without requiring application connection-setting changes. It requires Business Critical Edition or higher, and clients must use the connection object’s organization-and-connection-name URL so that Snowflake can redirect it to the promoted account during a service event.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!