ADA-C01 Question 520
Single answerGiven a scenario, determine account replication considerations with respect to the different Snowflake editionsA global company uses Snowflake Enterprise Edition for its primary production account in AWS us-east-1. The disaster recovery team wants to replicate this account to another region and also replicate a separate development account that runs on Standard Edition. During planning, the lead administrator asks which statement correctly reflects Snowflake account replication considerations across editions before they proceed.
Which statement is correct?
- A
Account replication is supported for Standard Edition accounts as long as the target account is in the same cloud provider.
- B
Account replication requires Business Critical Edition or higher for the accounts participating in replication.
- C
Account replication is available in all Snowflake editions, but failover between regions requires Enterprise Edition or higher.
- D
A source account on Enterprise Edition can replicate to a target account on Standard Edition if only databases are included in the replication group.
Show answer and explanation
Correct answer: B
Explanation
For Snowflake account replication, a primary design consideration is edition eligibility. Snowflake requires Business Critical Edition (or higher) for accounts that participate in replication and failover/failback. This applies regardless of whether the replication target is in another region or whether the administrator intends to replicate only a subset of eligible objects. In practice, administrators should verify edition requirements early in disaster recovery planning, especially in organizations where production and non-production accounts may be on different editions. This aligns with Snowflake documentation for replication and failover/failback, which identifies Business Critical Edition or higher as a prerequisite for these capabilities.
- A. Incorrect.
Incorrect. A common misconception is that account replication is mainly constrained by cloud provider or region. In reality, edition is a key requirement. Account replication and failover/failback features are not available for Standard Edition accounts. Simply keeping replication within the same cloud provider does not make Standard Edition eligible.
- B. Correct.
Correct. Snowflake account replication and related failover capabilities require Business Critical Edition or higher. This is an important planning consideration when designing disaster recovery across accounts and regions. If an organization has accounts on lower editions, those accounts must be upgraded before they can participate in account replication.
- C. Incorrect.
Incorrect. This option mixes availability across editions with failover capabilities, but the premise is wrong. Account replication itself is not available in all editions. It is not enough to have Enterprise Edition for cross-region failover; the replication feature requires Business Critical Edition or higher.
- D. Incorrect.
Incorrect. The limitation is not bypassed by narrowing scope to certain objects such as databases in a replication or failover group. Edition eligibility still applies to the accounts involved. An Enterprise Edition source cannot use account replication with a Standard Edition target account.