AWS Certified Solutions Architect – Associate (SAA-C02) — Question 407

A company is migrating a large, mission-critical database to AWS. A solutions architect has decided to use an Amazon RDS for MySQL Multi-AZ DB instance that is deployed with 80,000 Provisioned IOPS for storage. The solutions architect is using AWS Database Migration Service (AWS DMS) to perform the data migration. The migration is taking longer than expected, and the company wants to speed up the process. The company's network team has ruled out bandwidth as a limiting factor.
Which actions should the solutions architect take to speed up the migration? (Choose two.)

Answer options

• A. Disable Multi-AZ on the target DB instance.
• B. Create a new DMS instance that has a larger instance size.
• C. Turn off logging on the target DB instance until the initial load is complete.
• D. Restart the DMS task on a new DMS instance with transfer acceleration enabled.
• E. Change the storage type on the target DB instance to Amazon Elastic Block Store (Amazon EBS) General Purpose SSD (gp2).

Correct answer: A, C

Explanation

Disabling Multi-AZ on the target RDS instance eliminates the synchronous replication write overhead, which significantly speeds up data ingestion. Similarly, temporarily disabling backups and transaction logging minimizes the write latency on the target DB during the bulk load phase. Other options, like downgrading to gp2 storage or resizing the DMS instance, would either decrease performance or fail to address the target database's write bottlenecks.