Free Google Professional Cloud Database Engineer Actual Exam Questions - Question 2 Discussion
have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to
serve as a datastore for this new application. What should you do?
B Cloud Spanner is the only one designed for global transactions with strong ACID guarantees and high uptime, so it’s really the only option that checks all boxes here. The others fall short on either global ACID or availability.
Cloud SQL might seem like a solid choice because of its strong ACID support, but it’s not really built for that 99.999% global availability or scale. Firestore does offer some ACID transactions but it’s more tailored for semi-structured data and not full relational needs. Bigtable just can’t guarantee ACID at the transaction level, so it’s out. Cloud Spanner stands out because it’s basically built exactly for this kind of global, strongly consistent transactional workload. Anyone else think Firestore could still be useful if the transactional scope was smaller?
D imo, Bigtable is more for massive scale with eventual consistency, not strict ACID compliance. Since the question emphasizes ACID and global availability, Bigtable doesn't quite fit here.
B imo – global scale plus ACID compliance beats Firestore or Bigtable here.
Option C sounds less suitable since Cloud SQL is more for regional use and doesn't scale globally as well as Spanner. It might struggle with the high availability and global transactional requirements here.
B. Cloud Spanner is designed for global, ACID-compliant transactions with high availability, so it fits the bill better than the others here. Seen something similar on this topic before.