Google Cloud Professional Cloud Database Engineer — Question 66

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

Answer options

• A. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
• B. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
• C. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
• D. Shut down your existing Cloud SQL for MySQL instance, and enable HA.

Correct answer: C

Explanation

The correct answer is C because the gcloud instances patch command is specifically designed to modify existing Cloud SQL instances, including enabling high availability. Options A and B suggest creating a new instance, which is unnecessary when you can update the current one. Option D is not recommended as shutting down the instance may lead to unnecessary downtime.