A small scale retailer has been collecting its point of sale transaction in a PostgreSQL Da-tabase. They have raised funding for a strategic expansion goal in the next year that will see them grow sig

The correct answer is B. Spanner. Cloud Spanner (B) is the correct choice because the retailer needs a relational database (currently PostgreSQL) that can scale horizontally across multiple continents (Asia, Europe, North America) with strong consistency and high availability. Spanner is Google's globally distrib

Data Management and Database Solutions

Question

A small scale retailer has been collecting its point of sale transaction in a PostgreSQL Da-tabase. They have raised funding for a strategic expansion goal in the next year that will see them grow significantly in Asia, Europe, North America, Which Database option should they choose in Google Cloud?

Options

ABigQuary
BSpanner
CCloud SQL
DBigtable

How the community answered

(23 responses)

A
4% (1)
B
70% (16)
C
9% (2)
D
17% (4)

Explanation

Cloud Spanner (B) is the correct choice because the retailer needs a relational database (currently PostgreSQL) that can scale horizontally across multiple continents (Asia, Europe, North America) with strong consistency and high availability. Spanner is Google's globally distributed, strongly consistent, relational database designed for exactly this use case. Cloud SQL (C) supports PostgreSQL but is regional, not globally distributed, so it cannot efficiently serve users across three continents. Bigtable (D) is a NoSQL wide-column store, not relational. BigQuery (A) is an analytics data warehouse, not an OLTP transaction database.

Topics

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

Community Discussion

No community discussion yet for this question.

Full CLOUD-DIGITAL-LEADER Practice