Google Cloud Professional Cloud Database Engineer — Question 3

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

Answer options

• A. Set up manual backups.
• B. Create a PostgreSQL database on-premises as the HA option.
• C. Configure single zone availability for automated backups.
• D. Enable point-in-time recovery.
• E. Schedule automated backups.

Correct answer: D, E

Explanation

Enabling point-in-time recovery (D) allows for restoring the database to any specific moment, which is essential for high availability. Scheduling automated backups (E) ensures that data is regularly saved without manual intervention, further supporting HA. The other options either do not align with HA requirements or are not recommended by Google for this use case.