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?
- AFix schema incompatibilities before migration and test with a dry-run migration
- BIgnore errors and switch DNS immediately
- CMove to Bigtable instead
- DForce migration and fix issues in production
Show answerHide 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.