SAA-C03 Question 507
Single answerA company is planning to migrate its on-premises database to AWS. The source database is PostgreSQL, and the target is Amazon RDS for PostgreSQL. The company needs minimal downtime and wants to use the most suitable service for this homogeneous migration. Which service should the company use?
- A
AWS Database Migration Service (DMS)
- B
AWS Snowball
- C
Amazon RDS Automated Backups
- D
AWS DataSync
Show answer and explanation
Correct answer: A
Explanation
For homogeneous migrations, such as PostgreSQL to PostgreSQL, AWS Database Migration Service (DMS) is the most appropriate service. It supports minimal downtime migrations by enabling continuous data replication from the source database to the target database, ensuring a smooth transition without significant service interruptions.
- A. Correct.
AWS Database Migration Service (DMS) is the correct choice for homogeneous migrations like PostgreSQL to PostgreSQL. It supports minimal downtime and is designed to handle data replication during the migration process.
- B. Incorrect.
AWS Snowball is primarily used for large-scale data transfers involving physical devices. It is not suitable for database migrations requiring continuous replication or minimal downtime.
- C. Incorrect.
Amazon RDS Automated Backups is used for creating backups of Amazon RDS databases but does not facilitate database migrations.
- D. Incorrect.
AWS DataSync is designed for transferring files between on-premises and AWS storage services. It is not used for database migrations.