APICS Certified Supply Chain Professional (CSCP) — Question 181

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.

What should you do? (Choose two.)

Answer options

• A. Use an external read replica to migrate the databases to Cloud SQL.
• B. Use a read replica to migrate the databases to Cloud SQL.
• C. Use Database Migration Service to migrate the databases to Cloud SQL.
• D. Use a cross-region read replica to migrate the databases to Cloud SQL.
• E. Use replication from an external server to migrate the databases to Cloud SQL.

Correct answer: C, E

Explanation

The correct answers are C and E because Database Migration Service simplifies the migration process while ensuring minimal downtime and data consistency, making it ideal for this scenario. Option E allows for ongoing replication from an external server, which keeps the Cloud SQL databases synchronized with on-premises changes until the full transition occurs. Options A, B, and D do not facilitate the same level of ease or effectiveness for the migration process.