nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #92

Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application…

The correct answer is D. Use Database Migration Service. Database Migration Service (DMS) is purpose-built for migrating MySQL, PostgreSQL, and SQL Server databases to Google Cloud with CDC support, near-zero downtime, and no application changes.

Migrating and Transforming Data

Question

Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?

Options

  • AUse the native export and import functionality of the source database.
  • BCreate a database on Google Cloud, and use database links to perform the migration.
  • CCreate a database on Google Cloud, and use Dataflow for database migration.
  • DUse Database Migration Service.

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    9% (2)
  • C
    4% (1)
  • D
    83% (19)

Why each option

Database Migration Service (DMS) is purpose-built for migrating MySQL, PostgreSQL, and SQL Server databases to Google Cloud with CDC support, near-zero downtime, and no application changes.

AUse the native export and import functionality of the source database.

Native export and import requires the source database to be offline or frozen during the export, resulting in significant downtime and no continuous synchronization.

BCreate a database on Google Cloud, and use database links to perform the migration.

Database links are an Oracle-specific concept and are not a standard Google Cloud migration mechanism for MySQL, PostgreSQL, or SQL Server.

CCreate a database on Google Cloud, and use Dataflow for database migration.

Dataflow is a general-purpose data processing service and is not specifically designed for database migration with built-in CDC and schema replication support.

DUse Database Migration Service.Correct

Database Migration Service natively supports MySQL, PostgreSQL, and SQL Server as source databases and uses change data capture (CDC) to continuously replicate ongoing changes from the source to the destination. This enables near-zero downtime migrations because the destination stays synchronized with the source until the final cutover, requiring no application-level changes.

Concept tested: Database Migration Service with CDC for multi-engine migration

Source: https://cloud.google.com/database-migration/docs/overview

Topics

#Database Migration#Google Cloud DMS#Near-zero Downtime#Change Data Capture (CDC)

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice