Examkin

Question

Difficulty: MediumPlanning Database Options and Persistent Disk Types

A mobile gaming studio is designing the backend architecture for a new multiplayer game. The backend must store user profiles, real-time game state session documents, and player inventory data. The workload requires single-digit millisecond latency for document queries, automatic multi-region synchronization, dynamic horizontal scaling to millions of concurrent users, and zero database server management overhead. Which Google Cloud storage or database option best satisfies these requirements?

  1. Firestore in Native modeAnswer
  2. B
    Cloud SQL for PostgreSQL
  3. C
    Cloud Storage Standard bucket configured with Object Lifecycle Management
  4. D
    Self-managed NoSQL database deployed on Compute Engine Spot VMs with Local SSDs

Answer

Firestore in Native mode is the ideal Google Cloud solution for storing hierarchical document structures, user profiles, and game session state because it offers serverless auto-scaling, high availability across regions, and native document transactional queries.
Firestore in Native mode provides a serverless, document-oriented NoSQL database that automatically handles multi-region replication, high-concurrency scaling, single-digit millisecond latency, and real-time client SDK synchronization without operational overhead.

Step-by-Step Solution

1
Analyze data model and access pattern requirements
The requirement asks for storing non-relational document data (user profiles, player inventory, game state) with low-latency document queries and real-time syncing.
Matching access patterns to database capabilities ensures performance and cost optimization.
2
Evaluate operational overhead and scaling constraints
The solution must require zero database management overhead and scale horizontally to millions of concurrent users.
Fully managed serverless solutions like Firestore eliminate database provisioning, indexing maintenance, and server maintenance.
3
Select the optimal database option
Firestore in Native mode satisfies all requirements for managed NoSQL document storage with automatic multi-region replication.
Relational options (Cloud SQL), object storage (Cloud Storage), and unmanaged/ephemeral compute instances (Spot VMs) fail either operational or reliability criteria.

Key Concept

Selecting GCP Managed NoSQL Databases vs. Relational/Object Storage based on Workload Requirements
Rate this question

Topics

Planning Database Options and Persistent Disk Types

More questions from this topic