exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

Exam Professional Cloud Database Engineer topic 1 question 166 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 166
Topic #: 1
[All Professional Cloud Database Engineer Questions]

Your application uses a Cloud SQL for MySQL instance. Recently, you have noticed performance degradation during peak hours, leading to slow response times and frustrated users. You suspect that inefficient queries might be contributing to these issues. You want to pinpoint and analyze these problematic queries and pass them to the application team for optimizations. What should you do?

  • A. Use the underprovisioned instance recommender.
  • B. Increase the Cloud SQL instance read_buffer_size flag.
  • C. Enable and use Query Insights.
  • D. Create a Cloud Monitoring alert based on the database/mysql/queries metric.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
Sai_Vignesh
3 days, 3 hours ago
Selected Answer: B
Looks like B fits best.
upvoted 1 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 ...