Answer-first summary for fast verification
Answer: Use AWS Database Migration Service (DMS) for data extraction and AWS Glue for transformation and loading.
AWS Database Migration Service (DMS) is effective for extracting data from various sources, including on-premises databases. AWS Glue can then be used for transforming and loading this data into a target system, ensuring seamless integration from multiple sources.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are required to design a data pipeline that integrates data from multiple sources, including on-premises databases and cloud storage. Discuss how you would use AWS services to achieve this integration, focusing on data extraction, transformation, and loading processes.
A
Use AWS Data Pipeline for scheduling and orchestrating data transfers.
B
Use AWS Database Migration Service (DMS) for data extraction and AWS Glue for transformation and loading.
C
Use Amazon S3 for data storage and direct querying from multiple sources.
D
Use Amazon Redshift for data warehousing and direct integration with multiple sources.
No comments yet.