Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Associate Cloud Engineer All Questions

View all questions & answers for the Associate Cloud Engineer exam

Exam Associate Cloud Engineer topic 1 question 187 discussion

Actual exam question from Google's Associate Cloud Engineer
Question #: 187
Topic #: 1
[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?

  • 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.
  • B. Create an alert in Cloud Monitoring to alert when the percentage of 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.
  • C. Create 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.
  • D. Create an alert in Cloud Monitoring to alert when the percentage of high priority CPU utilization reaches 65%. Use database query statistics to identify queries that result in high CPU usage, and then rewrite those queries to optimize their resource usage.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
PAUGURU
Highly Voted 2 years, 7 months ago
Selected Answer: C
C looks correct, increase instances on single region if CPU above 65% https://cloud.google.com/spanner/docs/cpu-utilization#recommended-max
upvoted 15 times
...
denno22
Most Recent 1 month, 2 weeks ago
Selected Answer: C
C
upvoted 1 times
...
don_v
11 months, 3 weeks ago
I believe it's D. " Create an alert in Cloud Monitoring to alert when the percentage of high priority CPU utilization reaches 65%. Use database query statistics to identify queries that result in high CPU usage, and then rewrite those queries to optimize their resource usage." Is that ever possible to add any node to Cloud Spanner? Come on.
upvoted 2 times
don_v
11 months, 2 weeks ago
Taking it back. The answer is C. "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." https://cloud.google.com/spanner/docs/instances
upvoted 5 times
...
...
Ahmed_Y
1 year, 3 months ago
Selected Answer: C
I was keep thinking of A until I get to the link that thanks for @rsuresh27 provided bellow. the 45% is for the multi region.
upvoted 4 times
...
sabrinakloud
1 year, 7 months ago
Selected Answer: C
Metric Maximum for single-region instances Maximum per region for multi-region instances High priority total 65% 45% 24-hour smoothed aggregate 90% 90%
upvoted 3 times
...
dobberzoon
1 year, 7 months ago
Selected Answer: C
C makes sense.
upvoted 1 times
...
Aninina
2 years ago
Selected Answer: C
https://cloud.google.com/spanner/docs/cpu-utilization
upvoted 1 times
...
snkhatri
2 years, 2 months ago
Selected Answer: C
C looks correct
upvoted 1 times
...
AzureDP900
2 years, 5 months ago
shortest timeframe is key here , I am going with C as my answer.
upvoted 2 times
...
Tirthankar17
2 years, 5 months ago
Selected Answer: C
C is correct
upvoted 1 times
...
pfabio
2 years, 5 months ago
Selected Answer: C
Metric Maximum for single-region instances Maximum per region for multi-region instances High priority total> 65% 45% 24-hour smoothed aggregate> 90% 90%
upvoted 1 times
...
rsuresh27
2 years, 7 months ago
Selected Answer: C
The correct answer is C https://cloud.google.com/spanner/docs/cpu-utilization#recommended-max
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...