Google Cloud Professional Cloud Database Engineer — Question 36

You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

Answer options

• A. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
• B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
• C. Verify that the new replica is created automatically.
• D. Start the original primary instance and resume replication.

Correct answer: C

Explanation

The correct answer is C because Cloud SQL for MySQL is designed to automatically handle replica availability issues by creating a new replica if necessary. Option A and B involve manual intervention which is not required in this case, while option D is irrelevant since the primary instance is still operational.