Correct Answer: A multi-region database like Cloud Spanner
Cloud Spanner uses synchronous multi-region replication and Paxos consensus to ensure that a transaction is committed across regions before it's acknowledged, providing an RPO of 0...
Correct Answer
A multi-region database like Cloud Spanner
Why This Answer Is Correct
Cloud Spanner uses synchronous multi-region replication and Paxos consensus to ensure that a transaction is committed across regions before it's acknowledged, providing an RPO of 0.
This question evaluates your knowledge of Cloud SQL — a core concept tested in Professional Cloud Architect. Understanding Cloud SQL is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
Your company is deploying a global application that requires a relational database. The application must support multi-region writes with strong consistency and five-nines (99.999%) availability. Which database service should you recommend?
You need to migrate a 50 TB PostgreSQL database from on-premises to Cloud SQL. The business requires the cutover to have less than 1 hour of downtime. Which migration strategy is most effective?
A video game company needs to handle a massive influx of users during a tournament. They need a database that can handle millions of lightning-fast reads and writes with sub-10ms latency for player status updates. Which NoSQL service should they use?
What is the primary benefit of 'Regional Cloud SQL' (High Availability) over 'Standalone Cloud SQL'?