PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #96
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…
The correct answer is D. Select Cloud Spanner. Cloud Spanner is the only Google Cloud database service that combines 99.999% availability SLA, horizontal scalability, strong transactional consistency, and a relational interface compatible with open-source databases via its PostgreSQL dialect.
Question
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
- ASelect Bare Metal Solution for Oracle.
- BSelect Cloud SQL.
- CSelect Bigtable.
- DSelect Cloud Spanner.
How the community answered
(30 responses)- A7% (2)
- B7% (2)
- C20% (6)
- D67% (20)
Why each option
Cloud Spanner is the only Google Cloud database service that combines 99.999% availability SLA, horizontal scalability, strong transactional consistency, and a relational interface compatible with open-source databases via its PostgreSQL dialect.
Bare Metal Solution for Oracle is not open source, not automatically shardable, and is designed for lift-and-shift Oracle workloads rather than cloud-native global scalability.
Cloud SQL does not offer 99.999% availability or automatic horizontal sharding; it is a single-region managed database with a maximum of 99.95% HA SLA.
Bigtable is a NoSQL wide-column store that does not support relational schemas or strong multi-row transactional consistency, making it unsuitable for a payments gateway.
Cloud Spanner is a fully managed, globally distributed relational database that provides a 99.999% availability SLA for multi-region configurations, automatic horizontal sharding, and external consistency (strong consistency) across all transactions. It supports both a Google SQL dialect and a PostgreSQL-compatible dialect, satisfying the open-source database requirement for a global payments gateway.
Concept tested: Cloud Spanner global availability and horizontal scalability
Source: https://cloud.google.com/spanner/docs/overview
Topics
Community Discussion
No community discussion yet for this question.