SnowPro Advanced: Architect — Question 104

A company is using Snowflake in Azure in the Netherlands. The company analyst team also has data in JSON format that is stored in an Amazon S3 bucket in the AWS Singapore region that the team wants to analyze.

The Architect has been given the following requirements:

1. Provide access to frequently changing data
2. Keep egress costs to a minimum
3. Maintain low latency

How can these requirements be met with the LEAST amount of operational overhead?

Answer options

• A. Use a materialized view on top of an external table against the S3 bucket in AWS Singapore.
• B. Use an external table against the S3 bucket in AWS Singapore and copy the data into transient tables.
• C. Copy the data between providers from S3 to Azure Blob storage to collocate, then use Snowpipe for data ingestion.
• D. Use AWS Transfer Family to replicate data between the S3 bucket in AWS Singapore and an Azure Netherlands Blob storage, then use an external table against the Blob storage.

Correct answer: C

Explanation

Option C is correct because moving data to Azure Blob storage optimizes access and minimizes egress costs while using Snowpipe allows for efficient data ingestion with low latency. Option A does not address egress costs effectively, B requires additional management of transient tables, and D introduces unnecessary complexity with data replication that could increase operational overhead.