PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #186
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #186: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #186. The question stem and answer options stay visible for context.
Question
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-
Options
- AUse the underprovisioned instance recommender.
- BIncrease the Cloud SQL instance read_buffer_size flag.
- CEnable and use Query Insights.
- DCreate a Cloud Monitoring alert based on the database/mysql/queries metric.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.