Google Cloud Professional Cloud Database Engineer — Question 6

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?

Answer options

• A. Use Database Migration Service to migrate all databases to Cloud SQL.
• B. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
• C. Use data replication tools and CDC tools to enable migration.
• D. Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Correct answer: A

Explanation

The correct answer is A because using Database Migration Service is the recommended method for migrating databases to Cloud SQL, ensuring a streamlined and efficient process. Option B introduces unnecessary complexity by suggesting a mix of tools, which is not optimal for the migration strategy. Options C and D also complicate the process by incorporating additional tools that are not needed when following Google's best practices.