
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 Kafka streams, and can automate the ETL jobs, making it suitable for this scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company is integrating data from multiple sources, including a MySQL database, an S3 bucket containing JSON files, and a Kafka stream. 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
No comments yet.