Question

Difficulty: MediumPlanning Database Options and Persistent Disk Types

A digital publishing platform requires a fully managed GCP database service to store user profile documents, user session state, and content metadata. The workload demands flexible schema support, automatic multi-region replication with strong consistency, sub-second latency for document lookups, and zero database server management overhead. Which Google Cloud service should the cloud engineer select to meet these requirements?

  1. Firestore in Native modeAnswer
  2. B
    Cloud SQL for MySQL configured with high availability and cross-region read replicas
  3. C
    Cloud Storage Coldline storage bucket containing individual user profile JSON files
  4. D
    Self-managed MongoDB database hosted on Compute Engine Spot VMs backed by Standard Persistent Disk (pd-standard)

Answer

Firestore in Native mode is the correct service choice.
Firestore in Native mode is a serverless, document-oriented NoSQL database that automatically manages scaling, replication, and high availability across multi-region locations. It natively handles flexible JSON document hierarchies with strong consistency and requires no server administration.

Step-by-Step Solution

1
Analyze the workload requirements
Identified key requirements: fully managed document/JSON storage, flexible schema, multi-region strong consistency, sub-second latency, and zero server administration.
Matching technical constraints to GCP storage services ensures choosing the optimal service according to Google recommended practices.
2
Evaluate database paradigm options
Firestore is a serverless NoSQL document database designed for high availability, automatic scaling, document flexibility, and transactional multi-region support without database instance management.
Relational options like Cloud SQL require instance provisioning, maintenance, and fixed schemas, while object storage tiers like Coldline are intended for archival.

Key Concept

Selecting GCP Database and Storage Options based on workload requirements
Rate this question