ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
italiancloud2025
2 months, 1 week 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
7 months, 3 weeks ago
Selected Answer: D
Seems like the trigger on upload would be the fastest option
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago