Files from several sources arrive regularly in an Amazon S3 bucket. A data engineer needs to ingest new files into Amazon Redshift in near real time as soon as they appear in the S3 bucket. Which approach meets this requirement?
Choose an answer
Tap an option to check your answer.
Correct answer: Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift..
Why this is the answer
The correct approach is to use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift. S3 Event Notifications can be configured to trigger a Lambda function whenever new objects are created in the S3 bucket. The Lambda function can then execute a COPY command to ingest the new data into Amazon Redshift, providing near real-time ingestion. Scheduling a COPY command via Query Editor v2 is a batch process and not near real-time. Zero-ETL integration between Amazon Aurora and Amazon Redshift is for data replication from Aurora, not for ingesting files directly from S3. AWS Glue job bookmarks are useful for incremental processing in batch ETL jobs, but they introduce latency and are not designed for near real-time, event-driven ingestion from S3 to Redshift.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed