A global financial institution is designing a new ledger system. The system requires strong relational consistency (ACID transactions), must scale horizontally to handle millions of transactions per second, and must provide 99.999% availability across multiple continents. Which database service should you recommend?

Answer options:

Cloud SQL for PostgreSQL

Cloud Bigtable

Cloud Spanner

Firestore

How to approach this question

Look for the keywords: 'relational', 'horizontal scale', and 'global'.

Full Answer

C.Cloud Spanner✓ Correct

Cloud Spanner

Cloud Spanner is uniquely designed for this exact scenario. It provides the relational semantics (SQL, ACID) of a traditional database but scales horizontally across regions and continents like a NoSQL database, offering an industry-leading 99.999% SLA.

Common mistakes

Choosing Cloud SQL (A) because it's relational, forgetting it cannot scale horizontally for writes.

Question 20 All questions Question 22

Practice the full GCP Professional Cloud Architect Practice Exam 5

50 questions · hints · full answers · grading

More questions from this exam

Q01CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Hard Q02CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Medium Q03CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Medium Q04CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Medium Q05CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Easy

View all 50 questions →