Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day…

Question

Options

• AIssue a gcloud sql instances patch command to increase the number of vCPUs.
• BUpdate a MySQL database flag to increase the number of vCPUs.
• CIssue a gcloud compute instances update command to increase the number of vCPUs.
• DBack up the database, create an instance with additional vCPUs, and restore the database.

• A
  86% (25)
• B
  3% (1)
• C
  7% (2)
• D
  3% (1)

Explanation

The correct answer is A. The gcloud sql instances patch command is the correct and recommended way to modify a Cloud SQL instance's machine type, including adding vCPUs. It applies the change with only a brief instance restart (typically a few seconds), satisfying the 'minimal interruption' requirement. Option C (gcloud compute instances update) is used to modify Compute Engine VM instances, not Cloud SQL managed instances - these are separate services. Option B is incorrect because the number of vCPUs is determined by the machine type, not a MySQL database flag. Option D (backup, create new instance, restore) is the most disruptive approach, requiring significant downtime and manual effort.

No community discussion yet for this question.