SAP-C02 · Question #249
A company is migrating an on-premises application and a MySQL database to AWS. The application processes highly sensitive data, and new data is constantly updated in the database. The data must not…
The correct answer is B. Use AWS Database Migration Service (AWS DMS) to migrate the data to AWS. To migrate a 5TB MySQL database to Amazon RDS with minimal downtime, no internet transfer, and in-transit/at-rest encryption, AWS DMS using a private VPC endpoint and SSL over Direct Connect is the optimal solution.
Question
A company is migrating an on-premises application and a MySQL database to AWS. The application processes highly sensitive data, and new data is constantly updated in the database. The data must not be transferred over the internet. The company also must encrypt the data in transit and at rest. The database is 5 TB in size. The company already has created the database schema in an Amazon RDS for MySQL DB instance. The company has set up a 1 Gbps AWS Direct Connect connection to AWS. The company also has set up a public VIF and a private VIF. A solutions architect needs to design a solution that will migrate the data to AWS with the least possible downtime. Which solution will meet these requirements?
Options
- APerform a database backup.
- BUse AWS Database Migration Service (AWS DMS) to migrate the data to AWS.
- CPerform a database backup.
- DUse Amazon S3 File Gateway.
How the community answered
(41 responses)- A5% (2)
- B63% (26)
- C10% (4)
- D22% (9)
Why each option
To migrate a 5TB MySQL database to Amazon RDS with minimal downtime, no internet transfer, and in-transit/at-rest encryption, AWS DMS using a private VPC endpoint and SSL over Direct Connect is the optimal solution.
Performing a database backup and then restoring it will cause significant downtime, which violates the requirement for the least possible downtime.
AWS DMS is designed for near-zero downtime migrations, supports continuous replication (CDC), and when configured with an EC2 replication instance, a VPC endpoint for DMS, and SSL, it ensures data is encrypted in transit and does not traverse the public internet via Direct Connect.
Creating a new RDS instance from a backup file involves substantial downtime for the on-premises application, failing to meet the minimal downtime requirement.
Amazon S3 File Gateway is a file storage solution and is not suitable for migrating a relational database like MySQL; it would require a fundamental change to the application's data storage model.
Concept tested: Database migration with AWS DMS, private connectivity, and encryption
Source: https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html
Community Discussion
No community discussion yet for this question.