Google Cloud Professional Cloud Database Engineer — Question 138

You are migrating your critical production database from Amazon RDS for MySQL to Cloud SQL for MySQL by using Google Cloud's Database Migration Service. You want to keep disruption to your production database to a minimum and, at the same time, optimize migration performance. What should you do?

Answer options

• A. Create and start multiple Database Migration Service jobs to migrate your database to the target Cloud SQL for MySQL instance.
• B. Upgrade the Amazon RDS for MySQL primary instance to an instance with more vCPUs and memory, and then run Google Cloud's Database Migration Service.
• C. Create a single Database Migration Service migration job with initial load parallelism configured to maximum on the source Amazon RDS for MySQL read replica.
• D. Create a single Database Migration Service migration job with initial Load Parallelism configured to Maximum on the Amazon RDS for MySQL primary instance.

Correct answer: C

Explanation

The correct answer is C because using a read replica allows for offloading some of the read operations, which can enhance migration performance while minimizing disruption to the primary instance. Option A is ineffective as starting multiple jobs can lead to unnecessary complexity and contention. Option B, while it may improve performance, doesn't directly address the migration strategy and could still cause downtime. Option D does not leverage the benefits of a read replica, which is crucial for optimizing performance during the migration.