nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #198

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #198: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #198. The question stem and answer options stay visible for context.

Designing and planning database solutions

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

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#AlloyDB#High Availability (HA)#Disaster Recovery (DR)#Global Database Architecture
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions