Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 5

Question

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Use Database Migration Service to migrate all databases to Cloud SQL. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. Database Migration Service migrates databases to Cloud SQL/AlloyDB with minimal downtime. This option delivers the requirement at the lowest cost.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 5