GCP Data Engineer Question 16

[00:00:00]GCP data engineering professional certification question 16 of 30. Your company processes financial transactions globally. Each transaction must be written in a relational database with full asset guarantee. The database must support SQL joins across regions with zero data loss on failures. You need a single digit millisecond rights and a strong global consistency. Which GCP service meets all of these requirements?

[00:00:25]This question stacks multiple hard requirements and all of them must be met simultaneously. Asset guarantee, SQL joins, cross region, zero data loss, and single digit millisecond rights. And added to this, we have strong global consistency. Any option that fails even one of them is ruled out. What are our choices here? Cloud SQL with read replicas, Bigtable with row-level transactions, Cloud Spanner, and AlloyDB for PostgreSQL. Let's go through them.

[00:00:54]Cloud SQL with read replicas uses asynchronous replication. In a global setup, read replicas can lag behind the primary. That breaks the strong consistency requirement. So, this option is ruled out. Bigtable supports single row asset transactions only. Cross row and cross table transaction guarantees are not available. And there are no SQL joins. A financial transaction system needs more than this. So, this option is ruled out. AlloyDB is a high-performance PostgreSQL. It is fast, managed, and is an excellent choice for sure. But here's the thing, it is regional. [music] It does not offer multi-region strong consistency out of the box. So, this option is close, but not the right one.

[00:01:36]The last option that we want to discuss is Cloud Spanner. Cloud Spanner is the only managed relational database on GCP.

[00:01:42]It uses True Time technology to synchronize clocks globally, which supports SQL, provides asset level transactions, [music] and has a high-level performance. The correct option is option C, Cloud Spanner. Check out our GCP data engineering course at codecloud.com.