A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company's business partners has an a

Question

Options

• ACreate a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA
• BFrom account ACCOUNTA create a share of database MARKET_DB, and create a new database
• CCreate a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA
• DCreate a share of database MARKET_DB, and create a new database out of this share locally in

• A
  8% (3)
• B
  3% (1)
• C
  75% (30)
• D
  15% (6)

Explanation

Snowflake Data Sharing only works between accounts within the same cloud provider region. Since ACCOUNTA is on AWS us-east-1 and PARTNERB is on Azure East US 2, a direct share is not possible across cloud providers. The solution requires using Snowflake's database replication feature: create a new Snowflake account (e.g., AZABC123) in Azure East US 2 under the same organization, replicate MARKET_DB from ACCOUNTA to that Azure account, then create a share from the replicated database and have PARTNERB create a database from that share. This cross-cloud/cross-region sharing pattern is the required architecture when provider regions differ.

No community discussion yet for this question.