Answer-first summary for fast verification
Answer: Enable point-in-time recovery., Schedule automated backups.
To prepare your Cloud SQL instance for high availability (HA) following Google-recommended practices, you should focus on features that ensure your database is resilient and can recover quickly from failures. Manual backups (Option A) are not recommended for HA because they require manual intervention and are not automated. Creating a PostgreSQL database on-premises (Option B) does not align with Google's cloud-native approach and adds complexity without the benefits of cloud scalability and managed services. Configuring single zone availability for automated backups (Option C) does not provide HA as it does not protect against zone failures. Enabling point-in-time recovery (Option D) is crucial for HA as it allows you to recover your database to any point in time within your retention period, minimizing data loss. Scheduling automated backups (Option E) is also essential for HA as it ensures that your data is regularly backed up without manual intervention, providing a foundation for recovery in case of failure. Therefore, the correct options are D and E.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you configure your Cloud SQL instance for high availability (HA) to ensure 24/7 global accessibility for your digital-native business, following Google's best practices? (Select two 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.
No comments yet.