Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam ARA-R01 Topic 4 Question 34 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 34
Topic #: 4
[All ARA-R01 Questions]

An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company's Snowflake account be initiated? (Select TWO).

Show Suggested Answer Hide Answer
Suggested Answer: A, C

Snowpipe is a feature that enables continuous, near-real-time data ingestion from external sources into Snowflake tables. Snowpipe can ingest files from Amazon S3, Google Cloud Storage, or Azure Blob Storage into Snowflake tables on any cloud platform.Snowpipe can be triggered in two ways: by using the Snowpipe REST API or by using cloud notifications2

To ingest files from the company's AWS storage accounts into the company's Snowflake GCP account, the Architect can use either of these methods:

Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage. This method requires the client application to monitor the S3 buckets for new files and send a request to the Snowpipe REST API with the list of files to ingest.The client application must also handle authentication, error handling, and retry logic3

Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage. This method leverages the AWS Lambda service to execute a function that calls the Snowpipe REST API whenever an S3 event notification is received.The AWS Lambda function must be configured with the appropriate permissions, triggers, and code to invoke the Snowpipe REST API4

The other options are not valid methods for triggering Snowpipe:

Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage. This option is not feasible because Snowpipe does not support ingesting files from Amazon S3 Glacier storage, which is a long-term archival storage service.Snowpipe only supports ingesting files from Amazon S3 standard storage classes5

Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage. This option is not applicable because Snowpipe does not support cloud notifications from AWS SNS.Snowpipe only supports cloud notifications from AWS SQS, Google Cloud Pub/Sub, or Azure Event Grid6

Configure the client application to issue a COPY INTO <TABLE> command to Snowflake when new files have arrived in Amazon S3 Glacier storage. This option is not relevant because it does not use Snowpipe, but rather the standard COPY command, which is a batch loading method.Moreover, the COPY command also does not support ingesting files from Amazon S3 Glacier storage7Reference:

1: SnowPro Advanced: Architect | Study Guide8

2: Snowflake Documentation | Snowpipe Overview9

3: Snowflake Documentation | Using the Snowpipe REST API10

4: Snowflake Documentation | Loading Data Using Snowpipe and AWS Lambda11

5: Snowflake Documentation | Supported File Formats and Compression for Staged Data Files12

6: Snowflake Documentation | Using Cloud Notifications to Trigger Snowpipe13

7: Snowflake Documentation | Loading Data Using COPY into a Table

:SnowPro Advanced: Architect | Study Guide

:Snowpipe Overview

:Using the Snowpipe REST API

:Loading Data Using Snowpipe and AWS Lambda

:Supported File Formats and Compression for Staged Data Files

:Using Cloud Notifications to Trigger Snowpipe

:Loading Data Using COPY into a Table


by Marget at Jul 10, 2025, 02:38 AM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Cecilia
4 days ago
I also think option D could be a good choice as it involves configuring AWS SNS to notify Snowpipe about new files.
upvoted 0 times
...
Golda
6 days ago
I agree with Minna, option A seems like a practical way to initiate the ingestion of files into Snowflake.
upvoted 0 times
...
Minna
11 days ago
I think option A is a good choice because it involves configuring the client application to call the Snowpipe REST endpoint.
upvoted 0 times
...
Lucia
29 days ago
B and E? Nah, Glacier and COPY INTO Snowflake? That's just asking for trouble. A and C for the win!
upvoted 0 times
Leslee
4 days ago
A) Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
upvoted 0 times
...
...
Lashon
1 months ago
I'd go with A and D. The SNS notification should trigger the Snowpipe, nice and easy.
upvoted 0 times
Eladia
4 days ago
A and D seem like the most efficient options for ingesting files into Snowflake.
upvoted 0 times
...
Tarra
17 days ago
I agree, using SNS to notify Snowpipe is a straightforward solution.
upvoted 0 times
...
Melinda
29 days ago
A and D are good choices. SNS can easily trigger Snowpipe.
upvoted 0 times
...
...
Yuette
1 months ago
A and C seem like the right choices here. Gotta use that Snowpipe REST endpoint to get those files into Snowflake.
upvoted 0 times
Refugia
29 days ago
C) Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
upvoted 0 times
...
Bernardine
1 months ago
A) Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
upvoted 0 times
...
...

Save Cancel