Which Google Cloud database offers strongly consistent transactions, supports both relational and JSON data, and delivers globally distributed low latency across three continents?

The correct answer is B. Cloud Spanner multi region. Cloud Spanner multi-region is the only Google Cloud database that simultaneously delivers: (1) externally consistent (strongly consistent) distributed transactions via TrueTime, (2) a SQL-relational schema with JSON column support, and (3) multi-region replication across three…

Evaluating Google Cloud database services for globally distributed, strongly consistent, and transactional workloads.

Question

Options

AAlloyDB for PostgreSQL
BCloud Spanner multi region
CBigtable
DCloud SQL for PostgreSQL

How the community answered

(30 responses)

A
3% (1)
B
87% (26)
C
3% (1)
D
7% (2)

Explanation

Cloud Spanner multi-region is the only Google Cloud database that simultaneously delivers: (1) externally consistent (strongly consistent) distributed transactions via TrueTime, (2) a SQL-relational schema with JSON column support, and (3) multi-region replication across three or more continents with single-digit millisecond reads at each region. AlloyDB is a high-performance PostgreSQL service but is regional, not globally distributed. Bigtable is a wide-column NoSQL store that does not provide ACID transactions across rows. Cloud SQL for PostgreSQL is also regional and lacks global replication.

Topics

#Cloud Spanner#Global Distribution#Strong Consistency#Database Selection

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice