Skip to content
PCA Practice
SQ66

A team migrating databases uses Database Migration Service and encounters schema incompatibilities between source MySQL 5.7 and target Cloud SQL MySQL 8.0. What is the recommended approach?

  1. AFix schema incompatibilities before migration and test with a dry-run migration
  2. BIgnore errors and switch DNS immediately
  3. CMove to Bigtable instead
  4. DForce migration and fix issues in production
Show answer

Answer: A

Pre-migration testing and schema compatibility fixes are essential. Forcing migration with known issues risks data loss. Always validate with a dry run.

← SQ65Practice this topicSQ67 →