ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Cloud Engineer All Questions

View all questions & answers for the Associate Cloud Engineer exam
Go to 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 🗳️
by rsuresh27 at April 25, 2022, 12:58 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
PAUGURU
Highly Voted 3 years 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
...
85c887f
Most Recent 1 month ago
Selected Answer: D
For "best query performance" looks like D will work the best for a long-terms.
upvoted 1 times
...
denno22
6 months, 3 weeks ago
Selected Answer: C
C
upvoted 1 times
...
don_v
1 year, 4 months 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
1 year, 4 months 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, 8 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
2 years 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
2 years ago
Selected Answer: C
C makes sense.
upvoted 1 times
...
Aninina
2 years, 6 months ago
Selected Answer: C
https://cloud.google.com/spanner/docs/cpu-utilization
upvoted 1 times
...
snkhatri
2 years, 7 months ago
Selected Answer: C
C looks correct
upvoted 1 times
...
AzureDP900
2 years, 10 months ago
shortest timeframe is key here , I am going with C as my answer.
upvoted 2 times
...
Tirthankar17
2 years, 10 months ago
Selected Answer: C
C is correct
upvoted 1 times
...
pfabio
2 years, 11 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
3 years ago
Selected Answer: C
The correct answer is C https://cloud.google.com/spanner/docs/cpu-utilization#recommended-max
upvoted 4 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago