GoogleGoogle
PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #147
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #147: Real Exam Question with Answer & Explanation
See the full explanation below for the reasoning.
Optimizing database performance and cost
Question
mcnz.com migrated its busy ticketing platform database to Cloud SQL for MySQL six months ago and monitoring now shows persistently low CPU and memory usage which indicates the instance is oversized. What is the most efficient action to reduce costs while maintaining the current performance levels?
Options
- AMigrate the database to a self managed MySQL instance on Compute Engine to gain cost control
- BTurn off automated backups to reduce storage charges
- CReview and apply Cloud SQL rightsizing recommendations for the instance
- DResize to a smaller machine type that matches metrics from the last 90 days
Topics
#Cloud SQL#Cost Optimization#Rightsizing#Performance Tuning
Community Discussion
No community discussion yet for this question.