Examkin

Question

Difficulty: MediumSelecting and Designing Storage and Database Resources

A regional media publishing company is migrating its central subscription and billing management application to Google Cloud. The workload requires a transactional relational database schema, strong ACID consistency, standard SQL querying capabilities, and high availability within a single GCP region. The total database footprint is approximately 450 GB with predictable daily transactional throughput. Which database deployment architecture should you select to satisfy these requirements while minimizing operational cost and architectural complexity?

  1. Provision Cloud SQL for PostgreSQL with a high-availability regional configuration across two zones.Answer
  2. B
    Provision Cloud Spanner with a regional instance configuration across multiple zones.
  3. C
    Provision Cloud SQL for PostgreSQL using Customer-Supplied Encryption Keys (CSEK) for database storage encryption.
  4. D
    Order a Google Cloud Transfer Appliance to migrate the 450 GB database files directly into BigQuery for transactional processing.

Answer

Provisioning Cloud SQL for PostgreSQL with a high-availability regional configuration across two zones.
The correct response recommends Cloud SQL for PostgreSQL with a high-availability regional configuration. Cloud SQL natively supports relational SQL schemas, ACID transactions, and automated zonal failover within a single GCP region. With a 450 GB footprint, Cloud SQL meets all functional and availability requirements at a fraction of the operational complexity and cost of globally distributed alternatives.

Step-by-Step Solution

1
Analyze data model and query requirements
The application requires transactional relational integrity, ACID guarantees, and standard SQL support, matching a relational database service (Cloud SQL or Cloud Spanner).
Non-relational databases or object storage cannot provide ACID transactional guarantees for billing schemas.
2
Evaluate scale and regional boundary requirements
The dataset is 450 GB and operates strictly within a single GCP region without requiring global multi-region write replication.
Cloud SQL supports single-region databases up to 30 TB, making Cloud Spanner unnecessary for this capacity.
3
Determine high availability architecture and cost optimization
Cloud SQL configured with high availability (HA) provides automatic failover to a standby instance in a secondary zone within the same region.
HA Cloud SQL meets the availability objective while minimizing license, node, and operational overhead.

Key Concept

Selecting appropriate GCP storage and database services based on data model, transaction scale, regional scope, and cost efficiency.
Estimated Time:1m 30s
Rate this question

Topics

Selecting and Designing Storage and Database Resources