Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 49

Question

You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 49