PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #178
You want to migrate an on-premises MySQL database to Cloud SQL. The on-premises database currently has 16 cores and 64-GB of RAM and averages 75% CPU utilization to support an application with over…
The correct answer is B. Select a Cloud SQL for MySQL database with a machine configuration of 16 cores and 64-GB of. Matching your peak-sized on-prem configuration (16-vCPUs and 64-GB RAM) in Cloud SQL gives you the capacity to sustain your current 75% average CPU load plus headroom for traffic spikes. Downsizing to 12-vCPUs risks CPU saturation, while larger tiers would add unnecessary
Question
You want to migrate an on-premises MySQL database to Cloud SQL. The on-premises database currently has 16 cores and 64-GB of RAM and averages 75% CPU utilization to support an application with over 100.000 tables. You need to specify the most cost-effective machine size you need when migrating to Cloud SQL for MySQL. What should you do-
Options
- ASelect a Cloud SQL for MySQL database with a machine configuration of 12 cores and 48-GB of
- BSelect a Cloud SQL for MySQL database with a machine configuration of 16 cores and 64-GB of
- CSelect a Cloud SQL for MySQL database with a machine configuration of 32 cores and 256-GB of
- DSelect a Cloud SQL for MySQL database with a machine configuration of 64 cores and 768-GB of
How the community answered
(39 responses)- A3% (1)
- B74% (29)
- C15% (6)
- D8% (3)
Explanation
Matching your peak-sized on-prem configuration (16-vCPUs and 64-GB RAM) in Cloud SQL gives you the capacity to sustain your current 75% average CPU load plus headroom for traffic spikes. Downsizing to 12-vCPUs risks CPU saturation, while larger tiers would add unnecessary
Topics
Community Discussion
No community discussion yet for this question.