Discuss Snowflake ARA-R01 Exam Topic 4 Question 34

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).

AConfigure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

BConfigure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.

CCreate an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

DConfigure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.

EConfigure the client application to issue a COPY INTO <TABLE> command to Snowflake when new files have arrived in Amazon S3 Glacier storage.

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

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

30 comments · newest first

Octavio 10 months ago

B is a no-go, Glacier isn't for real-time ingestion.

Karina 10 months ago

Totally agree with A! Snowpipe is the way to go.

Maryln 10 months ago

Wait, can you really use Glacier for this? Sounds off.

Fausto 11 months ago

D is also a solid option, don't overlook it!

Inocencia 11 months ago

A and C are the right choices!

Jacquelyne 11 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.

Phyliss 11 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.

Bernardo 11 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.

Vi 12 months ago

I remember something about Snowpipe and how it can automatically ingest data, but I'm not sure if it works with Glacier.

Helaine 12 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.

Nathan 12 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.

Marjory 1 year 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.

Scot 1 year 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.

Raymon 1 year 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...'

Samuel 1 year ago

Haha, imagine trying to use Glacier for this. That's like trying to dig for treasure in a landfill!

Salena 1 year ago

↳ replying to Samuel

B: Yeah, that sounds like a good idea. And maybe we can also create an AWS Lambda function to help with the ingestion process.

Hyman 1 year ago

↳ replying to Samuel

A: I think we should configure the client application to call the Snowpipe REST endpoint when new files arrive in Amazon S3 storage.

Cecilia 1 year ago

I also think option D could be a good choice as it involves configuring AWS SNS to notify Snowpipe about new files.

Golda 1 year ago

I agree with Minna, option A seems like a practical way to initiate the ingestion of files into Snowflake.

Minna 1 year ago

I think option A is a good choice because it involves configuring the client application to call the Snowpipe REST endpoint.

Lucia 1 year ago

B and E? Nah, Glacier and COPY INTO Snowflake? That's just asking for trouble. A and C for the win!

Delfina 1 year ago

↳ replying to Lucia

C) Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

Leslee 1 year ago

↳ replying to Lucia

A) Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

Lashon 1 year ago

I'd go with A and D. The SNS notification should trigger the Snowpipe, nice and easy.

Eladia 1 year ago

↳ replying to Lashon

A and D seem like the most efficient options for ingesting files into Snowflake.

Tarra 1 year ago

↳ replying to Lashon

I agree, using SNS to notify Snowpipe is a straightforward solution.

Melinda 1 year ago

↳ replying to Lashon

A and D are good choices. SNS can easily trigger Snowpipe.

Yuette 1 year ago

A and C seem like the right choices here. Gotta use that Snowpipe REST endpoint to get those files into Snowflake.

Refugia 1 year ago

↳ replying to Yuette

C) Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

Bernardine 1 year ago

↳ replying to Yuette

A) Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.

Snowflake ARA-R01 Exam - Topic 4 Question 34 Discussion