An enterprise organization is migrating its internal human resources and payroll web application to Google Cloud. The workload operates entirely within a single GCP region, requires standard relational database capabilities with full ACID compliance, and has an estimated dataset size of 1.2 TB. The team needs automated backups, zero-downtime maintenance windows, and regional high availability across two zones. Which database resource should the cloud architect select to meet these technical requirements while minimizing operational complexity and cost?
- Provision a Cloud SQL for PostgreSQL instance with High Availability (regional instance with a standby instance in a secondary zone).Cevap
- BProvision a multi-region Cloud Spanner instance with multi-zone replication.
- CDeploy a self-managed PostgreSQL database on Compute Engine instances and manage disk encryption using Customer-Supplied Encryption Keys (CSEK).
- DExport database snapshots to Cloud Storage and order a Transfer Appliance for weekly offline database synchronization between availability zones.
Cevap
The cloud architect should select a Cloud SQL for PostgreSQL instance configured with High Availability (regional deployment).
Cloud SQL for PostgreSQL configured with High Availability (HA) provides a fully managed relational database platform that supports standard SQL and ACID transactions. It features synchronous storage replication across two zones within a single GCP region and automatic failover, satisfying all availability and storage requirements (1.2 TB is well within Cloud SQL's 64 TB limit) with minimal cost and operational burden.
Adım Adım Çözüm
Anahtar Kavram
Selecting Cloud SQL versus Cloud Spanner based on workload scope, storage volume, and geographical distribution requirements.
Tahmini Süre:1m 30s