Google Professional Cloud Database Engineer Exam - Topic 6 Question 15 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 15
Topic #: 6

[All Professional Cloud Database Engineer Questions]

Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

AWatch Query Insights for long running queries.

BWatch the Cloud SQL instance monitor for CPU utilization metrics.

CWatch the Cloud SQL recommenders for overprovisioned instances.

DWatch Cloud Trace for application requests that are failing.

Show Suggested Answer

Suggested Answer: A

by Ernie at Feb 24, 2023, 10:44 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Reyes

5 months ago

Wait, how does Sqlcommenter help with this?

upvoted 0 times

...

Patti

5 months ago

C? Really? Overprovisioning might not be the main problem.

upvoted 0 times

...

Silva

6 months ago

B seems useful, but not sure if it’s the root cause.

upvoted 0 times

...

Marget

6 months ago

A is important too, long queries can be a big issue.

upvoted 0 times

...

Meghann

6 months ago

Definitely D, gotta track those failing requests!

upvoted 0 times

...

Selene

6 months ago

I practiced a similar question where we had to analyze performance metrics, and I think Cloud Trace was the right choice there too.

upvoted 0 times

...

Lore

6 months ago

I feel like monitoring CPU utilization could help, but it might not pinpoint the exact cause of the failures.

upvoted 0 times

...

Lorean

6 months ago

I'm not entirely sure, but I remember something about Query Insights being useful for identifying long-running queries.

upvoted 0 times

...

Nu

6 months ago

I think watching Cloud Trace for application requests that are failing makes sense since it directly relates to the microservices.

upvoted 0 times

...

Colette

6 months ago

Blockchain is all about decentralization, so A has to be the right answer.

upvoted 0 times

...

Talia

6 months ago

I'm a little confused by this question. The options all seem relevant, but I'm not sure which one is the most important or "key" responsibility. I'll have to review my notes and try to figure out the best answer.

upvoted 0 times

...

Cherelle

7 months ago

Hmm, I'm not sure about this. The question mentions the database being protected, but doesn't explicitly say the Message Screening pattern is used for that purpose. I'll have to think this through carefully.

upvoted 0 times

...

Maia

11 months ago

I'm leaning towards D as well. Monitoring the Cloud SQL metrics and recommendations is useful, but won't directly tell us why the microservices are failing.

upvoted 0 times

Ashlee

11 months ago

D) Watch Cloud Trace for application requests that are failing.

upvoted 0 times

...

Adaline

11 months ago

B) Watch the Cloud SQL instance monitor for CPU utilization metrics.

upvoted 0 times

...

Junita

11 months ago

A) Watch Query Insights for long running queries.

upvoted 0 times

...

Gianna

11 months ago

I was also thinking D. Watching the application traces is the best way to see where the issues are occurring and troubleshoot the microservice failures.

upvoted 0 times

...