Professional Data Engineer

By Google · Question Mode

QuestionQ59

Designing data processing systems

MJTelco is creating a custom interface for sharing data. It has these requirements:

  1. It must perform aggregations across its petabyte-scale datasets.
  2. It must scan rows in a specific time range with a very fast response time (milliseconds).

Which combination of Google Cloud Platform products should you recommend?

Explanation

BigQuery is optimized for analytic SQL queries, including aggregations, over datasets at petabyte scale. Cloud Bigtable provides low-latency access to massive single-keyed and time-series datasets; a suitable row-key design supports efficient scans for specified time ranges. Together they satisfy the analytics and millisecond-response access requirements.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!