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…
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)- A92% (23)
- B4% (1)
- C4% (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
Community Discussion
No community discussion yet for this question.