Examkin

Question

Difficulty: MediumSelecting and Designing Storage and Database Resources

Match each enterprise application storage requirement to the most appropriate Google Cloud database or storage service based on data access patterns, scalability, and structural requirements.

  • Low-latency, high-throughput NoSQL key-value storage for real-time application session data and user profile caching.Cloud Bigtable
  • Globally distributed relational database requiring horizontal scaling and multi-region ACID transactional consistency.Cloud Spanner
  • Fully managed serverless enterprise data warehouse optimized for running ad-hoc analytical SQL queries on petabyte-scale data.BigQuery
  • Unstructured object storage service for storing compliance archives requiring write-once-read-many (WORM) retention policies.Cloud Storage

Answer

The requirement for real-time NoSQL key-value caching matches Cloud Bigtable; global ACID relational transactions match Cloud Spanner; petabyte-scale serverless SQL analytics matches BigQuery; and regulatory object archival matches Cloud Storage.
Each Google Cloud database and storage offering aligns with specific access patterns and architectural demands: Cloud Bigtable serves high-speed NoSQL key-value patterns; Cloud Spanner handles global ACID relational workloads; BigQuery executes serverless analytical OLAP queries; Cloud Storage manages unstructured object files with WORM regulatory capabilities.

Step-by-Step Solution

1
Analyze high-throughput NoSQL key-value caching access patterns.
Identify Cloud Bigtable as the optimal service for ultra-low latency NoSQL key-value workloads.
Cloud Bigtable scales seamlessly to handle massive write/read throughput with single-digit millisecond latencies.
2
Evaluate global transactional relational consistency requirements.
Identify Cloud Spanner as the correct choice for multi-region relational ACID transactions.
Cloud Spanner combines traditional relational schema support and ACID guarantees with global horizontal scalability.
3
Examine large-scale analytical query requirements.
Identify BigQuery as the appropriate serverless data warehouse.
BigQuery is designed to execute fast SQL queries over petabytes of structured or semi-structured analytical data.
4
Determine compliance object storage requirements.
Identify Cloud Storage with Bucket Lock features.
Cloud Storage provides durable unstructured object store functionality and legal hold/retention policy compliance.

Key Concept

Selecting and Designing Storage and Database Resources in Google Cloud
Rate this question

Topics

Selecting and Designing Storage and Database Resources