DEA-C01 Question 104
Select 2You are tasked with designing a serverless data processing workflow for a retail company. The workflow involves processing customer order data stored in an Amazon S3 bucket, performing data transformations, and loading the processed data into an Amazon Redshift table for analytics. Which combination of services can you use to build this serverless workflow efficiently?
- A
AWS Step Functions to orchestrate the workflow, AWS Lambda for data transformation, and Amazon Redshift COPY command for loading data
- B
AWS Glue for data transformation, Amazon EMR for orchestration, and Amazon Redshift COPY command for loading data
- C
AWS Step Functions to orchestrate the workflow, AWS Glue for data transformation, and Amazon Redshift COPY command for loading data
- D
Amazon Kinesis Data Firehose for orchestration, AWS Glue for data transformation, and Amazon Redshift COPY command for loading data
- E
AWS Lambda to orchestrate the workflow, AWS Glue for data transformation, and Amazon Redshift COPY command for loading data
Show answer and explanation
Correct answers: A, C
Explanation
Serverless workflows leverage services that do not require infrastructure management. AWS Step Functions is ideal for orchestrating serverless workflows, while AWS Lambda and AWS Glue can handle data transformation. The Amazon Redshift COPY command is optimized for loading data. Combining these services creates a scalable, cost-effective solution for serverless data processing workflows.
- A. Correct.
Correct: AWS Step Functions is a serverless orchestration service, AWS Lambda can transform the data, and the Amazon Redshift COPY command efficiently loads data into Redshift, making this a valid solution.
- B. Incorrect.
Incorrect: Amazon EMR is not serverless and is not suitable for orchestrating a fully serverless workflow.
- C. Correct.
Correct: AWS Step Functions is a serverless orchestration service, AWS Glue can handle data transformation, and the Amazon Redshift COPY command efficiently loads data into Redshift, making this another valid solution.
- D. Incorrect.
Incorrect: Amazon Kinesis Data Firehose is designed for streaming data delivery, not for workflow orchestration, so this is not a valid solution.
- E. Incorrect.
Incorrect: AWS Lambda is not designed to orchestrate workflows; AWS Step Functions or other orchestration tools should be used for this purpose.