GCP Associate Cloud Engineer Practice Question 45: Spanner Global Relational
Google Cloud Associate Cloud Engineer · Test 5 · question 5 of 10
A financial application needs a relational database with SQL support and strongly consistent transactions. Users are located on several continents, so writes must be possible from multiple regions, and the system must scale horizontally without manual sharding.
Which database should you choose?
Show answer and explanation
Answer:
Cloud Spanner is a horizontally scalable relational database that offers SQL and strongly consistent, ACID transactions across regions, and multi-region configurations allow writes from several geographies. It scales without manual sharding.
Option B scales reads through replicas, but writes still go to a single primary, and it scales vertically. Option C is a wide column NoSQL database that does not provide relational, multi-row ACID transactions across regions. Option D is an analytics data warehouse and is not designed for transactional workloads.
Reference: Spanner overview