CLOUD-DIGITAL-LEADER practice question 14 of 35

You are a DevOps Engineer in an E-commerce company that sells products globally, across the countries, Customers buy products, add them to carts or…

Full set: 411 questions
You are a DevOps Engineer in an E-commerce company that sells products globally, across the countries, Customers buy products, add them to carts or check-in stock from different parts of the world with different timestamps, you need to choose a database that can scale globally without any hassle and lots of developer support, it should be consistent across regions, can scale horizontally to support enormous user, automatically replicates, shards and even auto transaction pro-cessing. Which of the following database do you choose?
Answer options
A: Cloud SQL
B: Cloud Spanner Correct answer
C: Cloud Firestore.
D: Cloud Storage.
Correct Answer:
B. Cloud Spanner
Explanation

Cloud Spanner is Google Cloud’s globally-distributed relational database. It automatically shards data, replicates it synchronously across chosen regions, and provides external-consistent ACID transactions and SQL support. Nodes can be added or removed online, giving horizontal, virtually limitless scale without manual re-partitioning. Therefore it best satisfies the requirements for worldwide availability, built-in consistency, automatic replication/sharding, and rich developer tooling.

Why Incorrect

A. Cloud SQL – Primary instance is confined to a single region; replicas are read-only and asynchronous, so it cannot offer multi-region strong consistency or effortless horizontal scale.
C. Cloud Firestore – Although multi-region and auto-scaling, it is a NoSQL document store with limited relational querying and per-document transactional scope, not full SQL/ACID across rows.
D. Cloud Storage – Object storage for blobs; no schema, indexing, SQL, or transactional guarantees, thus not a database for operational workloads.

References

1. Google Cloud Spanner Overview – “Globally distributed, strongly-consistent database… automatic multi-region replication and horizontal scalability.” (Docs > Spanner > Overview, Section “Why Spanner”)

2. Google Cloud Spanner Concepts – “Offers horizontal scaling with automatic data sharding and externally consistent distributed transactions.” (Docs > Spanner > Architecture, para 1-3)

3. Google Cloud SQL Documentation – “Instances reside in a single region… only read-replicas can be in other regions and are asynchronous.” (Docs > Cloud SQL > High Availability, Section “Cross-region replicas”)

4. Google Cloud Firestore Documentation – “Provides per-document strong consistency; transactions limited to 500 documents.” (Docs > Firestore > Consistency & transactions, para 2-3)

5. Google Cloud Storage Overview – “Object storage for unstructured data; not intended for relational queries or transactions.” (Docs > Cloud Storage > Product Overview, first paragraph)

Scroll to Top