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

Amazon-DEA-C01 Exam - Topic 1 Question 26 Discussion

A company is building a new application that ingests CSV files into Amazon Redshift. The company has developed the frontend for the application.The files are stored in an Amazon S3 bucket. Files are no larger than 5 MB.A data engineer is developing the extract, transform, and load (ETL) pipeline for the CSV files. The data engineer configured a Redshift cluster and an AWS Lambda function that copies the data out of the files into the Redshift cluster.Which additional steps should the data engineer perform to meet these requirements?
A) Configure the bucket to send S3 event notifications to Amazon EventBridge. Configure an EventBridge rule that matches S3 new object created events. Set the Lambda function as the target.
B) Configure the S3 bucket to send S3 event notifications to an Amazon Simple Queue Service (Amazon SQS) queue. Configure the Lambda function to process the queue.
C) Configure AWS Database Migration Service (AWS DMS) to stream new S3 objects to a data stream in Amazon Kinesis Data Streams. Set the Lambda function as the target of the data stream.
D) Configure an Amazon EventBridge rule that matches S3 new object created events. Set an Amazon Simple Queue Service (Amazon SQS) queue as the target of the rule. Configure the Lambda function to process the queue.

Amazon-DEA-C01 Exam - Topic 1 Question 26 Discussion

Actual exam question for Amazon's Amazon-DEA-C01 exam
Question #: 26
Topic #: 1
[All Amazon-DEA-C01 Questions]

A company is building a new application that ingests CSV files into Amazon Redshift. The company has developed the frontend for the application.

The files are stored in an Amazon S3 bucket. Files are no larger than 5 MB.

A data engineer is developing the extract, transform, and load (ETL) pipeline for the CSV files. The data engineer configured a Redshift cluster and an AWS Lambda function that copies the data out of the files into the Redshift cluster.

Which additional steps should the data engineer perform to meet these requirements?

Show Suggested Answer Hide Answer
Suggested Answer: A

Option A is the most direct and operationally efficient way to trigger the existing Lambda-based load into Amazon Redshift whenever a new CSV file is uploaded to Amazon S3. The key requirement is event-driven automation on ''new object created'' events, and the study material explicitly describes using Amazon EventBridge to react to S3 uploads by creating a rule on the default event bus and routing matching events to a target application.

Compared with queue-based designs (Options B and D), Option A reduces components: there is no need to manage an SQS queue, batching/visibility timeout behavior, or retry semantics at the consumer layer. This is especially appropriate because the files are small ( 5 MB) and the Lambda function is already implemented to perform the copy/load step. Using DMS (Option C) is not designed for ''S3 object arrival Lambda Redshift'' event triggering; it introduces unnecessary services and operational work for a simple file-ingestion trigger.


Contribute your Thoughts:

0/2000 characters
Alyce
26 days ago
I think B could work too, but it adds extra complexity.
upvoted 0 times
...
Sage
1 month ago
Option A seems like the best choice for real-time processing.
upvoted 0 times
...
Suzi
2 months ago
I’m leaning towards option D because it combines EventBridge and SQS, which might help with processing multiple files efficiently.
upvoted 0 times
...
Lashunda
2 months ago
I practiced a similar question, and I feel like using SQS could add some reliability to the process, but I can't recall the exact benefits.
upvoted 0 times
...
Frankie
2 months ago
I think option A sounds familiar; it seems like a good way to trigger the Lambda function when new files are uploaded.
upvoted 0 times
...
Nobuko
2 months ago
I remember we discussed using S3 event notifications in class, but I'm not sure if EventBridge is the best choice here.
upvoted 0 times
...

Save Cancel