Snowflake SnowPro Advanced Architect: What is required to allow data sharing between two companies?

Table of Contents

Question
Answer
Explanation
Reference

Question

Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A. What is required to allow data sharing between these two companies?

A. Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
B. Ensure that all views are persisted, as views cannot be shared across cloud platforms.
C. Setup data replication to the region and cloud platform where the consumer resides.
D. Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.

Answer

C. Setup data replication to the region and cloud platform where the consumer resides.

Explanation

The correct answer is C. Setup data replication to the region and cloud platform where the consumer resides.

Snowflake offers a number of ways to share data between different Snowflake accounts, including:

Cross-region replication: This allows you to replicate data from one Snowflake region to another.
Cross-cloud replication: This allows you to replicate data from Snowflake to another cloud provider, such as Amazon S3 or Azure Blob Storage.
Data sharing: This allows you to share data with other Snowflake accounts, even if they are in different regions or cloud providers.

In this case, Company A and Company B are not on the same cloud platform. Therefore, the best way to share data between these two companies is to use cross-cloud replication. Snowflake can replicate data to a variety of cloud providers, including Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP).

To set up cross-cloud replication, you will need to create a replication rule in Snowflake. The replication rule will specify the source and destination data warehouses, as well as the schedule for replication.

Once the replication rule is created, Snowflake will start replicating data from the source data warehouse to the destination data warehouse. The replication process is asynchronous, so it may take some time for all of the data to be replicated.

Once the data has been replicated, Company B will be able to access the data from their Snowflake account.

Here are some additional details about each of the options:

Create a pipeline to write shared data to a cloud storage location in the target cloud provider: This is a viable option, but it is not the most efficient way to share data. It would require Company A to create a pipeline to write the data to a cloud storage location, such as Amazon S3 or Azure Blob Storage. Company B would then need to read the data from the cloud storage location. This would involve additional latency and complexity.
Ensure that all views are persisted, as views cannot be shared across cloud platforms: This is not necessary. Views can be shared across cloud platforms.
Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider: This is not true. Data sharing is possible even if the companies do not share the same cloud provider.

Reference

Snowflake SnowPro Advanced Architect certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Advanced Architect exam and earn Snowflake SnowPro Advanced Architect certification.