Examkin

Question

Difficulty: MediumSelecting and Designing Storage and Database Resources

Match each workload storage requirement to the most appropriate Google Cloud database or storage service based on data access patterns, scalability, and consistency models.

  • Low-latency, high-throughput NoSQL key-value store for serving real-time user recommendation features with single-digit millisecond latency.Cloud Bigtable
  • Fully managed relational database supporting global ACID transactions, horizontal scaling across regions, and high availability for financial trade settlement.Cloud Spanner
  • Regional relational database requiring full SQL support, ACID compliance, automatic failover, and read replicas for a regional CRM application.Cloud SQL
  • Unstructured object storage used to store media assets and system log archives with automated lifecycle management for cost tiering.Cloud Storage

Answer

Low-latency key-value feature serving maps to Cloud Bigtable; Global relational trade settlement with strong consistency maps to Cloud Spanner; Regional relational CRM application maps to Cloud SQL; Unstructured media assets and log archives with lifecycle policies map to Cloud Storage.
Each requirement directly matches the core capability of the corresponding GCP service: Cloud Bigtable for high-throughput NoSQL key-value lookups; Cloud Spanner for global multi-region relational ACID workloads; Cloud SQL for standard regional relational databases; and Cloud Storage for unstructured object storage with lifecycle management.

Step-by-Step Solution

1
Analyze access pattern and throughput demands for real-time recommendations.
Identified low-latency NoSQL key-value requirement, which aligns directly with Cloud Bigtable.
Cloud Bigtable provides sub-10ms performance at scale for key-value access patterns.
2
Evaluate transactional and consistency requirements for global financial trade settlement.
Identified global ACID compliance and horizontal scalability, which requires Cloud Spanner.
Cloud Spanner is the only fully managed GCP database delivering global scale combined with strong relational ACID transactions.
3
Evaluate regional relational database needs for a CRM application.
Selected Cloud SQL for standard regional relational engine management.
Cloud SQL offers managed PostgreSQL/MySQL/SQL Server with automated backups, HA, and read replicas within a single region.
4
Determine appropriate service for unstructured media files and log lifecycle management.
Selected Cloud Storage.
Cloud Storage is optimized for unstructured blob data and provides automated lifecycle transitions to lower-cost tiers.

Key Concept

GCP Storage and Database Resource Selection Criteria
Estimated Time:1m 30s
Rate this question

Topics

Selecting and Designing Storage and Database Resources