nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #109

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…

The correct answer is A. Use Database Migration Service to migrate all databases to Cloud SQL. The correct answer is A. Database Migration Service (DMS) is Google's native, fully managed migration tool that supports PostgreSQL migrations from both on-premises and AWS sources (including Amazon RDS) to Cloud SQL. The question explicitly requires Google-recommended…

Migrating database solutions

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?

Options

  • AUse Database Migration Service to migrate all databases to Cloud SQL.
  • BUse Database Migration Service for one-time migrations, and use third-party or partner tools for
  • CUse data replication tools and CDC tools to enable migration.
  • DUse a combination of Database Migration Service and partner tools to support the data migration

How the community answered

(25 responses)
  • A
    92% (23)
  • B
    4% (1)
  • C
    4% (1)

Explanation

The correct answer is A. Database Migration Service (DMS) is Google's native, fully managed migration tool that supports PostgreSQL migrations from both on-premises and AWS sources (including Amazon RDS) to Cloud SQL. The question explicitly requires Google-recommended practices and Google-native tools, which aligns directly with DMS. DMS supports continuous data replication (CDC) for minimal-downtime migrations and provides monitoring and cutover capabilities. Option B unnecessarily mixes third-party tools when DMS already handles all the stated sources. Option C describes capabilities that DMS already provides natively. Option D again introduces partner tools without justification when DMS covers all requirements.

Topics

#Database Migration Service (DMS)#Cloud SQL#PostgreSQL#Database Migration

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice