Google Cloud Professional Cloud Database Engineer — Question 107

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. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

Answer options

• A. Issue a gcloud sql instances patch command to increase the number of vCPUs.
• B. Update a MySQL database flag to increase the number of vCPUs.
• C. Issue a gcloud compute instances update command to increase the number of vCPUs.
• D. Back up the database, create an instance with additional vCPUs, and restore the database.

Correct answer: A

Explanation

The correct answer is A because using the gcloud sql instances patch command allows for the addition of vCPUs with minimal downtime. The other options either do not apply to scaling Cloud SQL instances directly (B and C) or involve unnecessary steps and longer downtime (D).