You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multip

The correct answer is A. Use Cloud Spanner to deploy the database.. Cloud Spanner is the ideal solution for a globally distributed, highly transactional relational workload. It provides ACID transactions, SQL support, strong consistency across regions, and automatic scaling-all critical for player authentication and inventory management at global

Designing and implementing highly available and scalable database solutions

Question

You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?

Options

AUse Cloud Spanner to deploy the database.
BUse Bigtable with clusters in multiple regions to deploy the database
CUse BigQuery to deploy the database
DUse Cloud SQL with a regional read replica to deploy the database.

How the community answered

(26 responses)

A
69% (18)
B
4% (1)
C
12% (3)
D
15% (4)

Explanation

Cloud Spanner is the ideal solution for a globally distributed, highly transactional relational workload. It provides ACID transactions, SQL support, strong consistency across regions, and automatic scaling-all critical for player authentication and inventory management at global scale. Bigtable (B) is a NoSQL wide-column store without relational or ACID transaction support. BigQuery (C) is an analytical data warehouse optimized for OLAP queries, not OLTP transactional workloads. Cloud SQL with regional read replicas (D) supports read scaling across regions but does not support multi-region writes or global strong consistency.

Topics

#Cloud Spanner#Global Databases#Transactional Databases#Database Selection

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice