DEA-C01 Question 293
Select 1You are tasked with designing a solution to automate the processing of daily sales data files uploaded to an S3 bucket. The solution must perform the following steps:
- Trigger a process when new files are uploaded to the S3 bucket.
- Extract, transform, and load (ETL) the data into an Amazon Redshift data warehouse.
- Ensure the solution is serverless and requires minimal operational overhead. Which combination of AWS services should you use to meet these requirements?
- A
Amazon S3, AWS Lambda, AWS Glue, and Amazon Redshift
- B
Amazon S3, AWS Batch, AWS Glue, and Amazon Redshift
- C
Amazon S3, Amazon Kinesis Data Streams, AWS Glue, and Amazon Redshift
- D
Amazon S3, AWS Lambda, Amazon EMR, and Amazon Redshift
- E
Amazon S3, AWS Lambda, AWS Glue, and Amazon DynamoDB
Show answer and explanation
Correct answer: A
Explanation
The combination of Amazon S3, AWS Lambda, AWS Glue, and Amazon Redshift provides a fully serverless, event-driven data processing pipeline. S3 triggers Lambda when new files are uploaded, Lambda invokes Glue for ETL operations, and the processed data is loaded into Redshift for storage and analysis. This approach meets all the requirements of the scenario, including automation, serverless architecture, and minimal operational overhead.
- A. Correct.
This is the correct combination. Amazon S3 triggers AWS Lambda when a new file is uploaded. AWS Lambda can invoke AWS Glue to perform the ETL process, and the transformed data is loaded into Amazon Redshift for analysis. This solution is entirely serverless and requires minimal operational overhead.
- B. Incorrect.
AWS Batch is not suitable for triggering processes when files are uploaded to S3. AWS Lambda is a better choice for event-driven processing in this scenario.
- C. Incorrect.
Amazon Kinesis Data Streams is not necessary for this use case because the files are already uploaded to S3. Kinesis is typically used for streaming data pipelines, which is not relevant here.
- D. Incorrect.
Amazon EMR is not serverless and introduces operational overhead. AWS Glue is a better choice for performing ETL tasks in a serverless manner.
- E. Incorrect.
Amazon DynamoDB is not relevant for this use case because the requirement is to load the data into Amazon Redshift, which is a data warehouse, not a NoSQL database.