Exam Professional Cloud Database Engineer topic 1 question 138 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 138
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by WOOJONE at May 29, 2025, 12:48 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!