Topic 1 Question 143
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?
Use the query editor v2 to schedule a COPY command to load new files into Amazon Redshift.
Use the zero-ETL integration between Amazon Aurora and Amazon Redshift to load new files into Amazon Redshift.
Use AWS Glue job bookmarks to extract, transform, and load (ETL) load new files into Amazon Redshift.
Use S3 Event Notifications to invoke an AWS Lambda function that loads new files into Amazon Redshift.
ユーザの投票
コメント(2)
- 正解だと思う選択肢: D
Seems like the trigger on upload would be the fastest option
👍 3dashapetr2024/09/04 - 正解だと思う選択肢: 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.
👍 1italiancloud20252025/02/18
シャッフルモード