Google Cloud Professional Cloud Database Engineer — Question 136

You are deploying a Cloud SQL for MySQL database to serve a non-critical application. The database size is 10 GB and will be updated every night with data stored in a Cloud Storage bucket. The database serves read-only traffic from the application during the day. The data locality requirement of this application mandates that data must reside in a single region. You want to minimize the cost of running this database while maintaining an RTO of 1 day. What should you do?

Answer options

• A. Create a Cloud SQL for MySQL instance with high availability (HA) enabled. Configure automated backups of the Cloud SQL instance, and use the default backup location.
• B. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in the same zone.
• C. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in a second region.
• D. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Configure automated backups of the Cloud SQL instance, and use a custom backup location to store backups in a Cloud Storage bucket in the same region.

Correct answer: D

Explanation

The correct answer is D because it allows for cost-effective management by disabling high availability, while still ensuring that backups are automated and stored in the same region to meet data locality requirements. Options A and B either involve unnecessary costs or do not adhere to the requirement of keeping data in a single region. Option C violates the data locality requirement by suggesting a backup in a second region.