Examkin

Question

Difficulty: MediumSelecting and Designing Storage and Database Resources

A financial technology enterprise is planning to migrate its core online transaction processing (OLTP) application from an on-premises PostgreSQL database to Google Cloud. The application requires standard relational SQL capabilities, strong ACID compliance, a 99.95% availability SLA within a single GCP region, and sub-10 millisecond write latency. The workload does not require global multi-region distribution or petabyte-scale horizontal scale-out. To minimize operational complexity and unnecessary costs while satisfying all technical requirements, which database resource strategy should you choose?

  1. Deploy a Cloud SQL for PostgreSQL instance configured with High Availability (regional failover) across two zones in the target region.Answer
  2. B
    Deploy a multi-region Cloud Spanner instance configured with multi-region database replication.
  3. C
    Order a GCP Transfer Appliance to physically transfer PostgreSQL database backups into BigQuery for operational OLTP processing.
  4. D
    Deploy Cloud SQL for PostgreSQL in a single zone and rely solely on IAM object permissions without configuring a standby failover instance or VPC Service Controls.

Answer

Deploy a Cloud SQL for PostgreSQL instance configured with High Availability (regional failover) across two zones in the target region.
The correct option proposes deploying Cloud SQL for PostgreSQL with High Availability configured across two zones. This directly fulfills all technical criteria—native PostgreSQL support, sub-10ms latency, relational ACID compliance, and a 99.95% regional availability SLA—while avoiding the higher cost and complexity of globally distributed databases.

Step-by-Step Solution

1
Analyze workload requirements
Identified OLTP access patterns requiring native PostgreSQL compatibility, sub-10ms write latency, ACID transactions, single-region deployment, and a 99.95% availability SLA.
Matching technical requirements to the appropriate managed database prevents over-provisioning and reduces operational cost.
2
Evaluate GCP managed database options
Cloud SQL for PostgreSQL configured with High Availability (regional failover) provides automated synchronous replication to a secondary zone, delivering 99.95% SLA within a single region.
Cloud Spanner is designed for globally distributed or massive horizontally scaled relational workloads, which is over-engineered and cost-prohibitive for standard single-region OLTP needs.

Key Concept

Selecting Cloud SQL HA vs. Cloud Spanner for Regional Relational OLTP Workloads
Estimated Time:1m 30s
Rate this question

Topics

Selecting and Designing Storage and Database Resources