AWS Certified Data Engineer – AssociateData Ingestion and TransformationEasy
A financial services company needs to migrate a 150 TB on-premises data warehouse (Microsoft SQL Server) to Amazon Redshift. The migration must be performed with minimal downtime, ensuring data consistency throughout the process, including ongoing replication of changes. The solution should be fully managed. Which AWS service is primarily designed for this type of database migration?
- AAWS Database Migration Service (DMS)
- BAWS Snowball Edge
- CAmazon Kinesis Data Firehose
- DAWS DataSync
Show answer & explanationAnswer & explanation
Correct answer: A. AWS Database Migration Service (DMS)
AWS Database Migration Service (DMS) is specifically designed for migrating relational databases, data warehouses, NoSQL databases, and other data stores to AWS. It supports both one-time migrations and continuous data replication with minimal downtime.
Why the other options are wrong
- B. AWS Snowball Edge is for physical data transfer of extremely large datasets (petabytes) where network transfer is impractical, not for logical database migration with ongoing replication.
- C. Amazon Kinesis Data Firehose is for real-time streaming data ingestion, not database migration.
- D. AWS DataSync is for transferring files or object data between on-premises storage and AWS, not for migrating relational databases with schema conversion and ongoing CDC.
AWS Database Migration Service (DMS)
A cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores to AWS quickly and securely.
- Migrates various database types
- Supports one-time migration and continuous replication (CDC)
- Minimal downtime during migration
Memory trick: DMS moves databases like magic.