ADA-C01 Question 207
Single answerUse region IDs and region groupsA global company is designing a replication and failover strategy for a Snowflake account that currently runs in AWS US West (Oregon). The administrator must choose a target account location that supports database replication and account failover while meeting data residency requirements in North America. During planning, the administrator reviews Snowflake region IDs and region groups to determine which target is eligible. Which target account location is the BEST choice?
- A
An account in AWS Canada Central because it is in the same region group as AWS US West (Oregon)
- B
An account in Azure East US because any North American region can be used for failover regardless of cloud platform
- C
An account in Google Cloud us-central1 because region IDs are interchangeable across cloud providers within the same geography
- D
An account in AWS Europe (Ireland) because account failover only depends on cloud provider, not region group
Show answer and explanation
Correct answer: A
Explanation
Snowflake administrators use region IDs and region groups to evaluate whether replication and failover targets are supported and appropriate. A region ID identifies a Snowflake deployment location and includes the cloud platform context, so similarly named regions across AWS, Azure, and Google Cloud are not equivalent. Region groups are used by Snowflake to organize supported replication/failover topologies, and administrators should verify compatibility using Snowflake documentation for replication and failover/failback support by region. In this scenario, the best answer is AWS Canada Central because it satisfies the North America residency requirement and aligns with the source account's AWS-based deployment and region-group-aware planning. Best practice is to confirm the exact source and target region IDs and supported region groups in Snowflake's current replication/failover documentation before implementation.
- A. Correct.
Correct. For replication and failover planning, administrators must consider both the cloud platform and Snowflake region group. Region groups are used to determine which regions can participate in certain cross-region and cross-cloud capabilities. Choosing AWS Canada Central keeps the deployment in North America and within the same relevant region grouping for AWS-based replication/failover planning, making it the best fit for the stated requirements.
- B. Incorrect.
Incorrect. A common misconception is that geographic proximity alone determines eligibility. In Snowflake, region IDs include the cloud provider, cloud region, and Snowflake region information, and supported replication/failover combinations are not simply based on being in North America. Cross-cloud scenarios require explicit support and are not assumed to work for 'any' region in the same geography.
- C. Incorrect.
Incorrect. Region IDs are not interchangeable across cloud providers. A Snowflake region on Google Cloud is distinct from one on AWS, even if the geographic area seems comparable. Administrators must use the actual Snowflake-supported region and region group mappings rather than assume equivalence based on names such as us-central1.
- D. Incorrect.
Incorrect. This option correctly stays on AWS but fails the data residency requirement in North America. It also reflects a misconception that cloud provider alone is the deciding factor. Region groups and the actual target geography both matter when selecting replication and failover targets.