SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 73

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?

Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.

Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.

Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.

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: C

The most efficient way to load data from Google Cloud Storage to Snowflake set up in Azure is by using tools to copy the data from Google Cloud Storage to Azure Blob Storage first and then loading the data from Blob Storage to Snowflake. This method ensures that data transfer and loading are done within the same cloud provider, reducing latency and complexity. Creating an external stage and loading data directly from Google Cloud Storage to Snowflake in Azure would involve cross-cloud transfers, which are less efficient.

Discussion

67422cbOption: B

I wish these questions would be worded better. It sounds like you are supposed to create an external stage in Google Cloud Storage, not in Snowflake referencing Google Cloud Storage. But I assume that the latter is what they meant.