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

Question

Options

• AUse a materialized view on top of an external table against the S3 bucket in AWS Singapore.
• BUse an external table against the S3 bucket in AWS Singapore and copy the data into transient
• CCopy the data between providers from S3 to Azure Blob storage to collocate, then use Snowpipe
• DUse AWS Transfer Family to replicate data between the S3 bucket in AWS Singapore and an

• A
  24% (8)
• B
  58% (19)
• C
  6% (2)
• D
  12% (4)

Explanation

An external table against the S3 bucket allows Snowflake (in Azure Netherlands) to query the JSON data in-place without fully migrating it, minimizing egress costs. Copying the result data into transient tables (which lack Fail-safe and have lower storage costs) caches frequently-used query results, reducing repeated cross-cloud latency for dashboards. When the source data changes, the external table always reflects the latest files. Option A (materialized view on external table) requires manual or scheduled refresh and lags on frequently changing data. Option C copies all data from S3 to Azure Blob Storage, incurring full cross-provider egress costs. Option D (AWS Transfer Family) adds significant operational overhead and replication complexity.

No community discussion yet for this question.