Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 143 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 143
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket.

Which solution will meet these requirements?

A. Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.
B. Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.
C. Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.
D. Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.

Show Suggested Answer

Suggested Answer: D 🗳️

by dashapetr at Sept. 5, 2024, 7:47 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

italiancloud2025

6 months ago

Selected Answer: D

A: No, Query Editor v2 isn't designed for event-driven near-real-time loads. B: No, the zero-ETL integration applies to Aurora, not to files arriving in S3. C: No, Glue job bookmarks are for batch ETL jobs, not near real-time processing. D: Sí, because using S3 Event Notifications to trigger a Lambda function enables near-real-time ingestion via COPY commands into Redshift.

upvoted 1 times

...

dashapetr

11 months, 2 weeks ago

Selected Answer: D

Seems like the trigger on upload would be the fastest option

upvoted 3 times

...