AWS Certified Database – Specialty — Question 168

A company is running its critical production workload on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must move the workload to a new
Amazon Aurora Serverless MySQL DB cluster without data loss.
Which solution will accomplish the move with the LEAST downtime and the LEAST application impact?

Answer options

• A. Modify the existing DB cluster and update the Aurora configuration to ג€Serverless.ג€
• B. Create a snapshot of the existing DB cluster and restore it to a new Aurora Serverless DB cluster.
• C. Create an Aurora Serverless replica from the existing DB cluster and promote it to primary when the replica lag is minimal.
• D. Replicate the data between the existing DB cluster and a new Aurora Serverless DB cluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled.

Correct answer: D

Explanation

Option D is the correct answer because using AWS Database Migration Service with CDC allows for continuous data replication, minimizing downtime and application impact. Option A is incorrect as modifying the existing DB cluster to Serverless could lead to significant downtime. Option B would cause downtime during the snapshot restoration process, while Option C might not ensure immediate consistency and could involve more lag, resulting in potential application issues.