3.1 Design and Implement Data Migration and Replication PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   A database engineer is evaluating migration strategies for a legacy database. The business can tolerate a few hours of downtime during a weekend, but the migration must be reversible if issues arise. Which strategy best fits these requirements?

   • AImmediate cutover without a rollback plan
   • BExtended outage migration with a fallback plan
   • CZero-downtime migration with continuous replication
   • DReverse replication from Google Cloud to source
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which action is typically part of a fallback procedure?

   • ADeleting the source database to free up resources
   • BDisabling all network access to the target
   • CRestoring the source database from a backup taken before migration
   • DConverting the target schema to match the source
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A company has migrated its on-premises MySQL database to Cloud SQL using DMS with continuous replication. After the cutover, they enabled reverse replication. A week later, a critical bug is found in the application that corrupts data in the Cloud SQL instance. The team decides to fall back to the on-premises database. What is the most important consideration before initiating the fallback?

   • ATake a backup of the Cloud SQL instance before falling back.
   • BEnsure that the corrupted data has not been replicated back to the on-premises database.
   • CNotify the business of the fallback plan.
   • DStop the application to prevent further corruption.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   In a zero-downtime migration using dual-writes, what does the application do during the migration period?

   • AWrites only to the target database and stops the source
   • BWrites data to both the source and target databases simultaneously
   • CWrites only to the source database and manually copies data later
   • DWrites to a staging database and then to the target
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A company is migrating its on-premises Oracle database to Cloud SQL for PostgreSQL using a third-party replication tool. The migration must have near-zero downtime, and the team wants to be able to fall back to the source for at least a week after cutover. What is the most important consideration for the fallback plan?

   • AEnsure the replication tool supports reverse replication from Cloud SQL back to Oracle.
   • BUse a load balancer to route traffic between the source and target based on health checks.
   • CKeep the application in read-only mode for the first week after cutover.
   • DTake a full backup of the source before cutover and store it in Cloud Storage.
   Reveal Solution Discussion Select an answer first