Google Exam Associate Cloud Engineer Topic 2 Question 96 Discussion

Actual exam question for Google's Associate Cloud Engineer exam

Question #: 96
Topic #: 2

[All Associate Cloud Engineer Questions]

You need to manage a Cloud Spanner Instance for best query performance. Your instance in production runs in a single Google Cloud region. You need to improve performance in the shortest amount of time. You want to follow Google best practices for service configuration. What should you do?

ACreate an alert in Cloud Monitoring to alert when the percentage of high priority CPU utilization reaches 45% If you exceed this threshold, add nodes lo your instance.

BCreate an alert in Cloud Monitoring to alert when the percentage to high priority CPU utilization reaches 45% Use database query statistics to identify queries that result in high CPU usage, and then rewrite those queries to optimize their resource usage

CCreate an alert in Cloud Monitoring to alert when the percentage of high priority CPU utilization reaches 65% If you exceed this threshold, add nodes to your instance

DCreate an alert in Cloud Monitoring to alert when the percentage of high priority CPU utilization reaches 65%. Use database query statistics to identity queries that result in high CPU usage, and then rewrite those queries to optimize their resource usage.

Show Suggested Answer

Suggested Answer: A

by Hershel at Sep 19, 2024, 09:50 AM

Limited Time Offer

25%

Off

Get Premium Associate Cloud Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Alise

1 months ago

You know, with all this talk about CPU utilization, I'm getting flashbacks to my college days when I had to optimize my code to avoid segmentation faults. Good times, good times.

upvoted 0 times

Gertude

3 days ago

B) Create an alert in Cloud Monitoring to alert when the percentage to high priority CPU utilization reaches 45% Use database query statistics to identify queries that result in high CPU usage, and then rewrite those queries to optimize their resource usage.

upvoted 0 times

...

Lashaunda

11 days ago

A) Create an alert in Cloud Monitoring to alert when the percentage of high priority CPU utilization reaches 45% If you exceed this threshold, add nodes to your instance.

upvoted 0 times

...

Lavonne

1 months ago

Option D is basically the same as Option B, just with a higher CPU threshold. I'd stick with Option B to be on the safe side and not wait until things get too critical.

upvoted 0 times

...

Margot

1 months ago

Haha, Option C is like throwing money at the problem. 65% CPU utilization is way too high before adding more nodes. I'd rather go with the smart approach of Option B.

upvoted 0 times

Julie

7 days ago

Option C is definitely not the way to go. 65% CPU utilization is too high.

upvoted 0 times

...

Dewitt

2 months ago

I agree, Option B is the way to go. Rewriting queries to optimize resource usage is a much more sustainable solution than just scaling up the instance.

upvoted 0 times

Tyra

1 months ago

Optimizing resource usage is key for improving query performance. Option B is the right move.

upvoted 0 times

...

Iola

1 months ago

Rewriting queries can really make a difference in performance. It's the way to go.

upvoted 0 times

...

Chara

2 months ago

Agreed, scaling up the instance should be a last resort. Optimizing queries is more efficient.

upvoted 0 times

...

Linn

2 months ago

Option B is definitely the best choice. It's important to optimize queries for better performance.

upvoted 0 times

...

Staci

2 months ago

Option B seems like the best approach to me. Monitoring CPU utilization and using query statistics to optimize resource-intensive queries is a proactive way to improve performance without just adding more nodes.

upvoted 0 times

...