AWS Certified Data Engineer – AssociateData Ingestion and TransformationMedium
A retail company has a large on-premises data warehouse (150 TB) that needs to be migrated to Amazon Redshift. The migration must occur with minimal downtime, and the data needs to be continuously replicated to Redshift after the initial load to keep the cloud data warehouse updated. The on-premises data warehouse uses PostgreSQL. Which AWS service should the company use for this migration and continuous replication?
- AAWS Database Migration Service (DMS)
- BAWS Snowball Edge
- CAWS DataSync
- DAWS Glue ETL
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 migration and continuous data replication (Change Data Capture - CDC) with minimal downtime, which is critical for this scenario.
Why the other options are wrong
- B. AWS Snowball Edge is a physical device for large-scale data transfer, primarily for offline or infrequent transfers, not continuous replication.
- C. AWS DataSync is for transferring large amounts of file or object data, not specifically for database migration with continuous replication.
- D. AWS Glue ETL is for data transformation and loading, not for migrating an entire database with continuous change data capture from an on-premises source.
AWS Database Migration Service (DMS)
A cloud service that helps migrate relational databases, data warehouses, NoSQL databases, and other types of data stores.
- Supports homogeneous and heterogeneous migrations.
- Enables continuous data replication (CDC) with minimal downtime.
- Can migrate data to and from various sources and targets, including Amazon Redshift.
Memory trick: DMS: Your database's smooth journey to the cloud.