Q: 6
Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?
Options
Discussion
Honestly, Google keeps pushing Spanner but I always think Cloud SQL could handle these if you pick the right engine and size it up. My choice is B. It claims high availability and supports open source DBs like Postgres and MySQL, so seems workable for most global apps. Maybe I overlook the auto sharding though, not sure.
D imo, Cloud Spanner is the only one here with global scaling, auto-sharding and that strict 99.999% SLA plus strong consistency. The others either can't hit those uptime guarantees or aren't natively globally distributed. Unless "open source" meant strict MySQL/Postgres required, D's the one. Disagree?
B. Cloud SQL actually supports open source engines so I picked that. Not sure if it can hit 99.999% or global horizontal scaling but seemed right for open source part.
I don’t think Cloud SQL (B) meets the 99.999% SLA or global auto-sharding requirements. Spanner (D) is specifically built for that, even if it’s not native open source. Trap here is picking B just for MySQL/Postgres compatibility.
C/D? Cloud SQL (B) supports open source but can't do global scale or 99.999% like Spanner. D fits.
Probably D. Only Spanner gives automatic sharding, global distribution, and true 99.999% SLA with strong consistency. Cloud SQL doesn't scale worldwide at that level. Pretty sure this is the only fit for mission-critical use.
Maybe B, since Cloud SQL supports open source databases and high availability, though Spanner's sharding is tempting.
Its D here. Cloud Spanner is built for global scale, auto-sharding, and strong consistency with super high (99.999%) availability. Cloud SQL can't match that uptime or scale across regions. Pretty sure Spanner fits this best.
Be respectful. No spam.