SnowPro Advanced: Architect — Question 90

A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure.

What would be the MOST efficient way to load data from the vendor into Snowflake?

Answer options

• A. Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.
• B. Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.
• C. Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.
• D. Create a Snowflake Account in the Google Cloud Platform (GCP), ingest data into this account and use data replication to move the data from GCP to Azure.

Correct answer: B

Explanation

Option B is the most efficient method as it directly integrates Google Cloud Storage with Snowflake through an external stage, allowing seamless data loading. Option A is inefficient as it requires creating a new Snowflake account for the vendor, which complicates the process. Option C introduces unnecessary steps by transferring data to Azure Blob storage first, while Option D involves creating another account in GCP and adds complexity with data replication.