
Answer-first summary for fast verification
Answer: AWS Glue
AWS Glue is a fully managed ETL service that is cost-effective and easy to use. It can connect to various data sources, including databases, S3, and REST APIs, and can automate the ETL jobs, making it suitable for this scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your company needs to integrate data from multiple sources, including a PostgreSQL database, an S3 bucket containing CSV files, and a REST API. The data needs to be transformed and loaded into an Amazon Redshift cluster. Which AWS service would you recommend for orchestrating this ETL process, considering the need for cost optimization and ease of use?
A
AWS Glue
B
Amazon EMR
C
AWS Lambda
D
Amazon Redshift Spectrum