GCP Associate Cloud Engineer Practice Question 45: Spanner Global Relational

Google Cloud Associate Cloud Engineer · Test 5 · question 5 of 10

Databasesmedium

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?

Select one answer
Show answer and explanation

Answer:

  • A. Cloud Spanner, in a multi-region configuration

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

Practice Test 5 ›

Study guides for Google Cloud Associate Cloud Engineer