Answer-first summary for fast verification
Answer: AWS Database Migration Service (DMS)
AWS Database Migration Service (DMS) is a comprehensive migration service that makes it easier to migrate databases to AWS with minimal downtime. It can migrate data from an on-premises SQL database to various AWS data stores, such as Amazon RDS, Amazon Redshift, and Amazon Aurora. To implement the migration, you can create a DMS replication instance, set up the source and target endpoints, and define the migration task. AWS Data Pipeline with AWS Glue is a data integration and processing service, but it is not specifically designed for data migration scenarios. AWS Direct Connect with Amazon S3 can be used for data transfer, but it does not provide the necessary tools for data migration. AWS Glue with Amazon Redshift Spectrum can be used for data cataloging and querying, but it is not designed for data migration scenarios.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are designing a data processing system that requires data migration from an on-premises SQL database to an AWS data store. Which AWS service should you use for the migration, and how should you implement the migration?
A
AWS Data Pipeline with AWS Glue
B
AWS Direct Connect with Amazon S3
C
AWS Database Migration Service (DMS)
D
AWS Glue with Amazon Redshift Spectrum