Google Cloud Professional Cloud Database Engineer — Question 32

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

Answer options

• A. Increase the number of processing units.
• B. Modify the database schema, and add additional indexes.
• C. Shard data required by the application into multiple instances.
• D. Decrease the number of processing units.

Correct answer: A

Explanation

The correct approach is to increase the number of processing units, as this directly enhances the resource capacity to handle the workload. Modifying the database schema or adding indexes may help in the long term, but they do not immediately address the high CPU utilization. Sharding data into multiple instances or decreasing processing units would likely worsen the performance issue.