google · Professional-Cloud-Database-Engineer · Q426 · multiple_choice · topic_1

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (…

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?

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.

Explanation

Selected Answer: C A and B are obviously wrong, but it's still a bit confusing with the last two: C - `gcloud instances patch` is not complete, it should be `gcloud sql instances patch`, so I would consider it to be wrong, if not the D - you can't edit your instance (i.e. enable HA) when it's shut down, you can only do it when instance is running, and then it will restart. So I'll go for C

Reference: examtopics_top_comment

Practice with progress tracking

Start tracked practice Pricing