AWS Certified Solutions Architect – Professional (SAP-C02) — Question 431
A company wants to migrate an Amazon Aurora MySQL DB cluster from an existing AWS account to a new AWS account in the same AWS Region. Both accounts are members of the same organization in AWS Organizations.
The company must minimize database service interruption before the company performs DNS cutover to the new database.
Which migration strategy will meet this requirement? (Choose two.)
Answer options
- A. Take a snapshot of the existing Aurora database. Share the snapshot with the new AWS account. Create an Aurora DB cluster in the new account from the snapshot.
- B. Create an Aurora DB cluster in the new AWS account. Use AWS Database Migration Service (AWS DMS) to migrate data between the two Aurora DB clusters.
- C. Use AWS Backup to share an Aurora database backup from the existing AWS account to the new AWS account. Create an Aurora DB cluster in the new AWS account from the snapshot.
- D. Create an Aurora DB cluster in the new AWS account. Use AWS Application Migration Service to migrate data between the two Aurora DB clusters.
Correct answer: A, B
Explanation
To minimize downtime during migration, a combination of seeding the initial data and replicating ongoing changes is required. Sharing a manual Aurora DB cluster snapshot (Option A) allows the target database to be quickly seeded with existing data, while AWS Database Migration Service (AWS DMS) (Option B) replicates delta changes continuously until the final DNS cutover. AWS Backup (Option C) does not offer a direct, low-downtime replication path, and AWS Application Migration Service (Option D) is meant for lift-and-shift server migrations rather than database-level replication.