Question

Difficulty: EasyPlanning Database Options and Persistent Disk Types

Match each Google Cloud storage or database requirement to its appropriate Google Cloud service or disk type.

  • High-performance, ephemeral block storage physically attached to the VM host server for microsecond latency requirementsLocal SSD
  • Fully managed relational database providing global scale, multi-region consistency, and ACID transactionsCloud Spanner
  • High-throughput NoSQL wide-column database optimized for large-scale analytical and real-time key-value dataCloud Bigtable
  • Standard durable network-attached block storage suitable for low-cost sequential workload data volumesStandard Persistent Disk (pd-standard)

Answer

Local SSD matches high-performance ephemeral block storage; Cloud Spanner matches global multi-region relational ACID requirements; Cloud Bigtable matches high-throughput NoSQL key-value data; Standard Persistent Disk (pd-standard) matches low-cost sequential block storage.
Each GCP database service and block storage option caters to distinct latency, persistence, scalability, and consistency models: Local SSD provides maximum IOPS with ephemeral host-attached disk; Cloud Spanner delivers globally scalable relational transactions; Cloud Bigtable supports ultra-high-throughput NoSQL operations; and Standard Persistent Disk provides low-cost network-attached HDD block storage.

Step-by-Step Solution

1
Analyze storage performance and lifespan requirements
Identify that physically attached disk storage with microsecond latency corresponds to Local SSD.
Local SSD provides the highest IOPS and lowest latency by residing on the physical host, though data does not persist past instance termination.
2
Evaluate relational vs NoSQL database architecture limits
Map global multi-region relational ACID needs to Cloud Spanner, and high-throughput key-value/wide-column data to Cloud Bigtable.
Cloud Spanner is designed for enterprise global relational workloads, while Cloud Bigtable handles non-relational heavy write/read throughput.
3
Identify block storage persistent disk performance tier
Map cost-effective HDD sequential access requirements to Standard Persistent Disk (pd-standard).
Standard Persistent Disk relies on HDDs providing cost-effective network storage for sequential access scenarios.

Key Concept

Selecting GCP Database and Storage Products Based on Workload Requirements
Rate this question