Answer-first summary for fast verification
Answer: Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.
Option D is CORRECT because using S3 Event Notifications to invoke an AWS Lambda function provides a mechanism for near real-time ingestion of new files into Amazon Redshift. When a new file arrives in the S3 bucket, S3 can trigger a Lambda function, which can then execute the necessary commands (such as a COPY command) to load the new data into Amazon Redshift. This solution is efficient for near real-time data ingestion as it responds to file uploads automatically without the need for manual intervention.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 5/58
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.
No comments yet.