Question

Difficulty: MediumPlanning Database Options and Persistent Disk Types

An enterprise cloud engineering team is evaluating Google Cloud database solutions and persistent block storage types for an infrastructure modernization project. Match each storage or database service on the left to the corresponding workload architecture requirement on the right.

  • Cloud SpannerGlobally distributed relational database requiring strong ACID transactional consistency and SQL querying across multiple regions.
  • Cloud BigtableHigh-throughput, low-latency NoSQL database optimized for heavy real-time analytical and time-series workloads.
  • Persistent Disk Balanced (pd-balanced)Cost-effective general-purpose block storage backed by SSD performance for standard enterprise application boot and data disks.
  • Local SSDEphemeral, non-persistent block storage physically attached to the Compute Engine host server for sub-millisecond scratch space.

Answer

Cloud Spanner matches globally distributed relational ACID requirements; Cloud Bigtable matches high-throughput NoSQL time-series workloads; Persistent Disk Balanced matches cost-effective SSD general-purpose block storage; Local SSD matches ephemeral physically attached scratch storage.
Each service aligns directly with its fundamental design characteristics: Cloud Spanner handles global relational transactions; Cloud Bigtable provides scalable NoSQL high-throughput storage; pd-balanced delivers cost-effective durable block storage; Local SSD supplies ultra-fast ephemeral host storage.

Step-by-Step Solution

1
Identify the database requirements involving multi-region relational SQL and strict ACID transactions.
Map Cloud Spanner to the requirement for globally distributed ACID relational data.
Cloud Spanner is designed specifically for global scale while maintaining full relational capabilities and ACID transactions.
2
Identify high-throughput NoSQL ingestion and time-series analytical needs.
Map Cloud Bigtable to the low-latency high-throughput NoSQL requirement.
Bigtable handles massive throughput and large-scale NoSQL data with low latency.
3
Differentiate between durable network-attached block storage and ephemeral host-attached storage.
Map pd-balanced to general-purpose enterprise virtual machine storage and Local SSD to high-performance temporary scratch storage.
pd-balanced offers durable network block storage with balanced IOPS/cost, whereas Local SSD provides host-bound ephemeral performance.

Key Concept

Selecting GCP Managed Databases and Block Storage Options
Rate this question