CLOUD-DIGITAL-LEADER practice question 25 of 35

A multinational retail company has approached you to help design its systems. They have millions of transactions at their point of sale systems across the world that need to be captured, stored, and analyzed. They are seeing more growth and expect to expand into even more geographies. Which database would be appropriate for them?

Full set: 411 questions
Answer options
A: Cloud Datastore
B: Cloud Storage
C: Cloud Spanner Correct answer
D: Cloud SQL
Correct Answer:
C. Cloud Spanner
Explanation

Cloud Spanner is Google Cloud’s fully-managed, relational database that delivers horizontal scaling, strong ACID transactions, and synchronous replication across regions. It is explicitly designed for high-volume, globally-distributed OLTP workloads such as retail point-of-sale systems that generate millions of transactions per day and must continue to grow into new geographies while maintaining consistency and availability. Datastore and Cloud Storage are non-relational/object stores, and Cloud SQL is limited to single-region instances and vertical scaling, making them unsuitable for the stated scale and global consistency needs.

Why Incorrect

A. Cloud Datastore – Document NoSQL store; lacks relational schema and global, strongly consistent transactions needed for POS financial data.
B. Cloud Storage – Object storage; not a database, no transactional semantics or query capabilities.
D. Cloud SQL – Single-region, vertically scaled MySQL/PostgreSQL/SQL Server; cannot provide global horizontal scalability or multi-region consistency.

References

1. Google Cloud documentation, “Cloud Spanner: Horizontally scalable, strongly consistent, relational database service,” Product overview, para. 1-3 (https://cloud.google.com/spanner/docs).

2. Google Cloud, “Choose Your Google Cloud Database,” Table 1: Workload vs. product fit, last updated 2023-10-12.

3. J. C. Corbett et al., “Spanner: Google’s globally-distributed database,” ACM Trans. Comput. Syst., 31(3), 2013, pp. 1-22, DOI:10.1145/2491245 – Sec. 1 (global scalability) & Sec. 7 (performance).

4. Stanford CS345A Course Notes, “Cloud Data Management Systems,” Lecture 5, slide 21: Cloud Spanner characteristics (global transactions, horizontal scale).

Scroll to Top