nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #147

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. W

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #147. The question stem and answer options stay visible for context.

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

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.

Topics

#Cloud SQL#Cost Optimization#Rightsizing#Performance Tuning
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice