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 ARA-R01 Exam - 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:

0/2000 characters
Submit Cancel
Octavio
5 months ago
B is a no-go, Glacier isn't for real-time ingestion.
upvoted 0 times
...
Karina
6 months ago
Totally agree with A! Snowpipe is the way to go.
upvoted 0 times
...
Maryln
6 months ago
Wait, can you really use Glacier for this? Sounds off.
upvoted 0 times
...
Fausto
6 months ago
D is also a solid option, don't overlook it!
upvoted 0 times
...
Inocencia
6 months ago
A and C are the right choices!
upvoted 0 times
...
Jacquelyne
6 months ago
I’m a bit confused about the difference between S3 and S3 Glacier for this scenario. I thought Snowpipe only works with S3, but I could be wrong.
upvoted 0 times
...
Phyliss
7 months ago
I feel like I saw a question similar to this where SNS was involved. It might be a way to notify Snowpipe about new files, but I can't recall the details.
upvoted 0 times
...
Bernardo
7 months ago
I think using an AWS Lambda function to call the Snowpipe REST endpoint is a common practice for triggering ingestion. That seems like a good option.
upvoted 0 times
...
Vi
7 months ago
I remember something about Snowpipe and how it can automatically ingest data, but I'm not sure if it works with Glacier.
upvoted 0 times
...
Helaine
7 months ago
I'm not totally sure about this one. The options mention a few different AWS services like S3, Glacier, and SNS. I'll need to think through how each of those could potentially integrate with Snowflake's Snowpipe. Might be worth reviewing the Snowpipe documentation again.
upvoted 0 times
...
Nathan
7 months ago
Okay, I've got this. The correct answers are A and C - configuring the client app to call the Snowpipe REST endpoint when new files arrive in S3, or creating an AWS Lambda function to do the same. The other options don't seem to involve Snowpipe directly.
upvoted 0 times
...
Marjory
8 months ago
Hmm, I'm a bit confused by the options here. I know Snowpipe is used for data ingestion, but I'm not sure about the details of how it integrates with AWS services like S3 and Glacier. I'll need to review my notes on that.
upvoted 0 times
...
Scot
8 months ago
This looks like a straightforward question about integrating AWS and Snowflake. I think the key is to focus on the options that mention Snowpipe, since that's the Snowflake service for ingesting data.
upvoted 0 times
...
Raymon
9 months ago
A and C are the way to go. I'm just picturing the architect trying to explain Glacier to the client. 'Yeah, it's where data goes to die...'
upvoted 0 times
...
Samuel
9 months ago
Haha, imagine trying to use Glacier for this. That's like trying to dig for treasure in a landfill!
upvoted 0 times
Salena
8 months ago
B: Yeah, that sounds like a good idea. And maybe we can also create an AWS Lambda function to help with the ingestion process.
upvoted 0 times
...
Hyman
8 months ago
A: I think we should configure the client application to call the Snowpipe REST endpoint when new files arrive in Amazon S3 storage.
upvoted 0 times
...
...
Cecilia
10 months 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
10 months ago
I agree with Minna, option A seems like a practical way to initiate the ingestion of files into Snowflake.
upvoted 0 times
...
Minna
10 months 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
10 months 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
Delfina
9 months 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
...
Leslee
10 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
...
...
Lashon
11 months ago
I'd go with A and D. The SNS notification should trigger the Snowpipe, nice and easy.
upvoted 0 times
Eladia
10 months ago
A and D seem like the most efficient options for ingesting files into Snowflake.
upvoted 0 times
...
Tarra
10 months ago
I agree, using SNS to notify Snowpipe is a straightforward solution.
upvoted 0 times
...
Melinda
10 months ago
A and D are good choices. SNS can easily trigger Snowpipe.
upvoted 0 times
...
...
Yuette
11 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
10 months 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
11 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