This question centers aroundcross-cloud ingestionusingSnowpipe, where the Snowflake account is onGoogle Cloud, but the source data resides inAmazon S3. Sinceautomatic Snowpipe event-based integration (using AWS SNS)is only supported when Snowflake is deployed onAWS, this limits the options.
In a multi-cloud scenario (e.g., S3 to GCP-hosted Snowflake), onlymanual triggering of Snowpipeis available, typically through theSnowpipe REST API.
Option A – Correct
You can configure your client application to call theSnowpipe REST APIwhen files are available. This is suitable and supported forcross-cloud ingestion, such as from AWS S3 into a Snowflake account hosted on GCP.
Official Extract:
"For cloud platforms other than AWS, or when using Snowpipe in a cross-cloud or external storage configuration, the REST API must be used to trigger ingestion."
Source:Snowflake Docs – Using Snowpipe REST API
Option C – Correct
AWS Lambda can be used toinvoke the Snowpipe REST APIwhen files arrive in S3. This is a common pattern in cross-cloud integrations, acting as a middle layer.
Official Extract:
"You can use an AWS Lambda function to call the Snowpipe REST API when new files are added to your S3 bucket. This pattern works for Snowflake accounts hosted outside of AWS."
Source:Snowflake Docs – Automating Snowpipe REST API Calls
Option B – Incorrect
S3 Glacier is an archival storage service and isnot supportedfor direct loading into Snowflake, since data is not immediately accessible.
Option D – Incorrect
UsingAWS SNS for auto-notificationis only supported whenSnowflake is deployed on AWS. Since this question specifies Snowflake onGCP, SNS-based integration isnot supported.
Official Extract:
"Snowpipe supports Amazon S3 event notifications (SNS/SQS) only for Snowflake accounts hosted on AWS."
Source:Snowflake Docs – Supported Cloud Platforms
Option E – Incorrect
Similar to Option B, S3 Glacier isnot a valid sourcefor data loading because it does not provide real-time file access.
[References:, Snowflake Documentation – Snowpipe Overview, Snowpipe REST API, Automating Snowpipe with Lambda, Automatic Ingestion Support – Cloud Limitations, , , , , ]
