Correct Answer: Cross-region replication (Read Replicas) with promotion capability
Cross-region replication provides near-real-time updates to a remote region, ensuring a low RPO (Recovery Point Objective) in the event of a catastrophic regional failure....
Correct Answer
Cross-region replication (Read Replicas) with promotion capability
Why This Answer Is Correct
Cross-region replication provides near-real-time updates to a remote region, ensuring a low RPO (Recovery Point Objective) in the event of a catastrophic regional failure.
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'?