Google Cloud Professional Cloud Database Engineer — Question 153

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?

Answer options

• A. Select a Cloud SQL for MySQL database with a machine configuration of 12 cores and 48 GB of RAM.
• B. Select a Cloud SQL for MySQL database with a machine configuration of 16 cores and 64 GB of RAM.
• C. Select a Cloud SQL for MySQL database with a machine configuration of 32 cores and 256 GB of RAM.
• D. Select a Cloud SQL for MySQL database with a machine configuration of 64 cores and 768 GB of RAM.

Correct answer: B

Explanation

The correct answer is B, as it matches the existing configuration of the on-premises database, ensuring that the performance requirements are met without over-provisioning resources. Option A provides insufficient resources, while options C and D significantly exceed the necessary specifications, leading to unnecessary costs.