Google Associate Cloud EngineerEnsuring successful operation of a cloud solutionMedium

A developer is building a new application that needs to store frequently accessed, semi-structured data. The application requires high read and write throughput, low latency, and automatic scaling without needing to provision servers. The data model is flexible and does not require strong transactional consistency across multiple tables. Which Google Cloud database is the most appropriate choice?

  1. AFirestore
  2. BCloud SQL
  3. CCloud Spanner
  4. DBigQuery
Show answer & explanation

Correct answer: A. Firestore

Firestore is a NoSQL document database that offers high read/write throughput, low latency, and automatic scaling. Its flexible data model and eventual consistency (within a collection group) are well-suited for semi-structured data and applications that prioritize scalability and flexibility over strict transactional integrity across multiple tables.

Why the other options are wrong

  • B. Cloud SQL is a relational database and requires a structured schema, which is not suitable for 'semi-structured data' and 'flexible data model'. It also requires some provisioning and scaling management.
  • C. Cloud Spanner is a globally distributed, strongly consistent, relational database. While it offers high performance and scaling, it's designed for strong transactional consistency and structured data, making it overkill and less flexible for 'semi-structured data' with 'flexible data model' that doesn't need multi-table strong consistency.
  • D. BigQuery is a serverless data warehouse optimized for analytical queries on massive datasets, not an operational database for frequently accessed, low-latency, transactional operations for an application.

Firestore

A flexible, scalable NoSQL document database for mobile, web, and server development that offers real-time synchronization and offline support.

  • NoSQL document database
  • Flexible schema (semi-structured data)
  • High read/write throughput and low latency
  • Automatic scaling and fully managed
  • Real-time updates and offline support

Memory trick: Firestore: The 'flexible diary' for your app's data.

More Ensuring successful operation of a cloud solution questions