Google Cloud Professional Cloud Database Engineer — Question 14

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

Answer options

• A. Use external server replication.
• B. Use Data Migration Service.
• C. Use Cloud SQL for MySQL external replica.
• D. Use the mysqldump utility and binary logs.

Correct answer: C

Explanation

The correct answer is C, as using Cloud SQL for MySQL external replica allows you to create managed replicas that can scale reads efficiently. Option A, external server replication, may not provide the same level of management as Cloud SQL. Option B, Data Migration Service, is used for migrating data rather than creating replicas. Option D, mysqldump and binary logs, is more manual and not suited for ongoing replication needs.