GCP Professional Data Engineer Practice Question

Your multiplayer game stores player profiles, achievements, and leaderboard scores in a relational schema. Traffic peaks at 25 000 writes and 50 000 reads per second worldwide. Players demand that a score appears simultaneously in all regions, and business owners want a single SQL endpoint instead of sharding logic. The operations team cannot manage manual failover or schema changes. Which managed storage service best meets these requirements?

Cloud Spanner deployed in a multi-region configuration
BigQuery using streamed inserts into partitioned tables
Cloud SQL for MySQL with cross-region read replicas and automatic failover
Bigtable with multi-cluster replication enabled

Report Issue

Answer Description

Cloud Spanner is a fully managed, horizontally scalable relational database that provides strong external consistency and synchronous replication across multiple regions, so a write is visible globally as soon as it commits. It exposes a single SQL endpoint and automates maintenance tasks such as online schema changes and automatic failover.

Cloud SQL cannot provide synchronous cross-region consistency; its read replicas are asynchronously replicated and may lag. BigQuery is an analytical (OLAP) warehouse optimized for batch queries, not for high-QPS transactional updates. Bigtable delivers low-latency key-value access but is a NoSQL wide-column store and offers eventual, not strong, consistency in multi-cluster replication.

Ask Bash

Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.