Exam Professional Cloud Database Engineer topic 1 question 32 discussion

not good answers ;) a think A+B correct

A seems to be the first go to choice, if that does not resolve we can move to other options, But first A.

In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%20the%20CPU%20utilization%20of%20the%20instance%20is%20above%20the%20recommended%20level%2C%20you%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%20auto%20scaling. "Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling." Indexes and schema are reviewed post identifying query with slow performance. Refer : https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#review-schema

I surprised with the chosen answer. The correct answer is B. When addressing high CPU utilization in a Google Cloud Spanner instance, you should first consider B. Modify the database schema, and add additional indexes. High CPU utilization in a database often occurs due to inefficient queries or lack of appropriate indexes.

By modifying the database schema and adding additional indexes, you can optimize query performance and potentially reduce the CPU utilization in Cloud Spanner. This approach focuses on improving the efficiency of the database and aligning it with the specific requirements of the consumer inventory application. It is important to monitor the impact of these changes and make further optimizations as needed.

A. B is wrong since that would increase CPU utilization even further and the question does not mention anything being wrong with index design. D is wrong since that would reduce CPU capacity and thus increase the load on the remaining CPUs. Cloud Spanner does not autoscale. It’s up to you to allocate the number of nodes or processing units to keep CPU utilization under 65%. So add more processing units.

Compute capacity defines amount of server and storage resources that are available to the databases in an instance. When you create an instance, you specify its compute capacity as a number of processing ***** units or as a number of nodes, with 1000 processing units being equal to 1 node. range9005

A: Increase the number of processing units.

A is correct answer B is not correct because modifying schema is not a correct option

Increase the number of processing units.