Examkin

Soru

Zorluk: KolaySelecting and Designing Storage and Database Resources

A regional medical provider plans to migrate a single-region relational database to Google Cloud. The application requires full ACID compliance, standard SQL query support, and managed backups, but operates exclusively within one geographical area without requiring global multi-region scalability. Which Google Cloud service should you recommend to meet these requirements with minimal cost and complexity?

  1. Cloud SQL for PostgreSQLCevap
  2. B
    Cloud Spanner
  3. C
    Transfer Appliance
  4. D
    Cloud Storage configured with Customer-Supplied Encryption Keys (CSEK)

Cevap

Cloud SQL for PostgreSQL is the optimal selection for standard single-region relational workloads requiring ACID compliance.
Cloud SQL for PostgreSQL provides a fully managed relational database engine supporting full ACID transactions and standard SQL within a single region. It matches the application's requirement for a regional database while maintaining minimal cost and operational complexity.

Adım Adım Çözüm

1
Analyze the workload characteristics
The workload requires standard relational SQL capabilities, ACID compliance, managed operations, and single-region availability.
Identifying spatial scope and relational database constraints dictates service selection.
2
Evaluate Google Cloud database offerings against constraints
Cloud SQL provides managed PostgreSQL/MySQL/SQL Server instances optimized for single-region relational database workloads without multi-region overhead.
Cloud Spanner is over-provisioned for regional needs, while Cloud Storage and Transfer Appliance are not database services.

Anahtar Kavram

Selecting Cloud SQL versus Cloud Spanner based on workload scope and distribution needs.
Bu soruyu puanla

Konular

Selecting and Designing Storage and Database Resources