Professional Data EngineerBuilding and operationalizing data processing systemsEasy

A global online gaming company needs to store petabytes of user gameplay data, including session logs, in-game actions, and chat messages. This data will be frequently accessed for real-time analytics dashboards, machine learning model training, and historical trend analysis. The company requires a highly scalable, low-latency storage solution that can handle millions of reads and writes per second. Which Google Cloud storage service is best suited for this requirement?

  1. ACloud Bigtable
  2. BBigQuery
  3. CCloud Storage (Standard class)
  4. DCloud Spanner
Show answer & explanation

Correct answer: A. Cloud Bigtable

Cloud Bigtable is a NoSQL wide-column database service designed for large analytical and operational workloads, offering high throughput and low latency for petabyte-scale data, making it ideal for the described use case.

Why the other options are wrong

  • B. BigQuery is a serverless data warehouse designed for large-scale analytical queries, not for low-latency transactional reads/writes or operational data storage for real-time applications.
  • C. Cloud Storage is an object storage service, suitable for data lakes and archives, but not optimized for low-latency, high-volume reads/writes of structured or semi-structured data for real-time analytics.
  • D. Cloud Spanner is a globally distributed relational database, offering strong consistency and high availability, but typically overkill and more expensive for purely analytical, non-relational, high-volume operational data like gameplay logs.

Cloud Bigtable

A fully managed, scalable NoSQL wide-column database service for large analytical and operational workloads, offering high throughput and low latency.

  • Ideal for petabyte-scale data with high read/write volume.
  • Suitable for real-time analytics, IoT, and machine learning.
  • NoSQL, wide-column store.

Memory trick: Bigtable handles Big Traffic and Big Data with Speed.

More Building and operationalizing data processing systems questions