A company is migrating a critical on-premises database to Amazon RDS for MySQL. The migration must have zero data loss (RPO=0) during the cutover. The on-premises database is 5 TB. Which TWO steps are REQUIRED to achieve this using AWS Database Migration Service (DMS)? (Select TWO)

Answer options:

Configure an AWS DMS task with full load and ongoing replication (CDC).

Use AWS Snowball Edge to transfer the initial 5 TB backup.

Stop all writes to the on-premises database, wait for DMS to sync the final changes, and then point the application to RDS.

Enable Multi-AZ on the on-premises database.

Use AWS Schema Conversion Tool (SCT) to convert the MySQL schema.

Configure bidirectional replication in DMS.

How to approach this question

Identify the DMS mode for continuous sync (CDC) and the operational step for cutover (stop writes, sync, switch).

Full Answer

Configure an AWS DMS task with full load and ongoing replication (CDC). Stop all writes to the on-premises database, wait for DMS to sync the final changes, and then point the application to RDS.

To achieve near-zero downtime and zero data loss, use DMS with Change Data Capture (CDC). During the cutover window, you must stop writes to the source, let DMS apply the final changes to the target, and then update the application connection strings.

Common mistakes

Thinking SCT is required for all migrations; it's only for heterogeneous (e.g., Oracle to PostgreSQL).

Question 54 All questions Question 56

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 1

75 questions · hints · full answers · grading

More questions from this exam

Q01An enterprise has 50 VPCs across two AWS Regions. They need to establish transitive routing betwe...Hard Q02A company uses AWS Organizations. The security team wants to ensure that no IAM user or role can ...Medium Q03An application requires a relational database with an RPO of 1 second and an RTO of less than 1 m...Hard Q04A company is setting up a new multi-account environment. They want to automate the provisioning o...Medium Q05An organization wants to allocate AWS costs to specific business units. They use AWS Organization...Hard

View all 75 questions →