Google Associate Cloud EngineerEnsuring successful operation of a cloud solutionMedium
A data engineering team is setting up a new data pipeline that requires a fully managed, serverless NoSQL database service capable of handling petabytes of data with single-digit millisecond latency. The data structure is highly flexible and subject to frequent changes. Which Google Cloud service is best suited for this requirement?
- ABigtable
- BFirestore
- CCloud SQL
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: A. Bigtable
Bigtable is a fully managed, highly scalable NoSQL database service specifically designed for large analytical and operational workloads, capable of handling petabytes of data with consistently low latency, making it ideal for the described data pipeline.
Why the other options are wrong
- B. Firestore is a flexible, scalable NoSQL document database, suitable for mobile, web, and server development. While it offers low latency, Bigtable is optimized for far larger analytical datasets (petabytes) and higher throughput.
- C. Cloud SQL is a relational database service, not a NoSQL database, and is less suited for petabyte-scale flexible data with single-digit millisecond latency across all operations.
- D. Cloud Spanner is a globally distributed, strongly consistent, relational database, but it's not a NoSQL solution and is typically used for transactional workloads requiring strong consistency at global scale, rather than flexible schema petabyte-scale analytical data.
Bigtable
A fully managed, highly scalable NoSQL wide-column database service designed for large analytical and operational workloads, offering petabyte scale and low latency.
- NoSQL wide-column store
- Petabyte scale and high throughput
- Single-digit millisecond latency
- Ideal for time-series data, marketing data, IoT data
Memory trick: NoSQL means 'No Schema, Often Scalable, Quick Lookups'.