Google Professional Data Engineer Question 129
Single answerGoogle Cloud PlatformA retail company is designing a scalable system to store customer transaction data. The data consists of high-volume, real-time streams that need to be written with low latency and retrieved based on specific key lookups. The system must be able to scale horizontally as the data grows. Which Google Cloud managed service should you choose?
- A
Cloud Bigtable
- B
Cloud Spanner
- C
Cloud SQL
- D
Cloud Storage
Show answer and explanation
Correct answer: A
Explanation
The use case describes a system requiring low-latency writes, high-throughput capabilities, and scalability for real-time, key-based lookups. Cloud Bigtable is specifically designed to handle such workloads with horizontal scalability and is a managed NoSQL database optimized for time-series and analytical data, making it the best fit for the scenario described.
- A. Correct.
Cloud Bigtable is optimized for low-latency, high-throughput workloads and is highly suitable for real-time analytics and key-based lookups. It also scales horizontally, making it ideal for the described use case.
- B. Incorrect.
Cloud Spanner is a globally distributed relational database that offers strong consistency and SQL queries, but it is not specifically optimized for high-throughput key/value lookups or low-latency writes, which are critical for this scenario.
- C. Incorrect.
Cloud SQL is a relational database service suited for transactional workloads with structured data and SQL queries. It is not the best choice for handling high-volume, real-time streams with horizontal scalability.
- D. Incorrect.
Cloud Storage is a highly durable, object-based storage solution. While it is excellent for storing large, unstructured data objects, it is not ideal for real-time, low-latency key-based lookups.