PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #198
You are migrating your company's critical ecommerce platform from an on-premises PostgreSQL database (utilizing PostgreSQL stored procedures) to a highly available solution on Google Cloud. The…
The correct answer is B. Deploy an AlloyDB cluster in the primary region with a high-availability instance configuration, and. AlloyDB is PostgreSQL-compatible (including stored procedures) and provides regional high availability with automatic failover that meets a 5-minute RTO. Cross-region read replicas use low-lag asynchronous replication suitable for a 30-second RPO while keeping writes in a…
Question
You are migrating your company’s critical ecommerce platform from an on-premises PostgreSQL database (utilizing PostgreSQL stored procedures) to a highly available solution on Google Cloud. The platform requires an extremely low downtime (Recovery Time Objective (RTO) – 5 minutes) and minimal data loss (Recovery Point Objective – 30 seconds). The platform serves a global customer base with peak traffic distributed across multiple continents, though the primary transactional data resides in a single geographic region for regulatory compliance. You need to design a cloud database solution that meets the RTO/RPO requirements while optimizing for global read access and local transactional integrity. What should you do-
Options
- AImplement a single-instance Spanner deployment configured for multi-regional data replication.
- BDeploy an AlloyDB cluster in the primary region with a high-availability instance configuration, and
- CDeploy a single-region AlloyDB cluster with a primary instance and a read replica in the same
- DImplement a multi-regional Cloud SQL for PostgreSQL deployment with read replicas in different
How the community answered
(41 responses)- A15% (6)
- B44% (18)
- C10% (4)
- D32% (13)
Explanation
AlloyDB is PostgreSQL-compatible (including stored procedures) and provides regional high availability with automatic failover that meets a 5-minute RTO. Cross-region read replicas use low-lag asynchronous replication suitable for a 30-second RPO while keeping writes in a single compliant region. This design delivers local transactional integrity and globally scaled reads with minimal downtime and data loss.
Topics
Community Discussion
No community discussion yet for this question.