Correct Answer: Use Database Migration Service (DMS) for an online migration
Database Migration Service (DMS) supports serverless, high-speed, online migrations for PostgreSQL to Cloud SQL, minimizing downtime by keeping the target in sync with the source u...
Correct Answer
Use Database Migration Service (DMS) for an online migration
Why This Answer Is Correct
Database Migration Service (DMS) supports serverless, high-speed, online migrations for PostgreSQL to Cloud SQL, minimizing downtime by keeping the target in sync with the source until the cutover.
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?
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'?
An organization is using Google Cloud Spanner for their transactional database. They want to optimize performance for a table that has a high volume of writes. What is a key design best practice in Spanner to avoid 'hotspots'?