Question 19 of 139
Single answerYour customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are
expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the
database to Google Cloud, and you need to ensure minimal downtime. What should you do?
ACreate a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump
file.
BUse the mysqldump utility to take a backup of the existing on-premises database, and then import it into
Cloud SQL.
CCreate a Compute Engine VM, install MySQL on the VM, and then import the dump file.
✓DCreate an external replica, and use Cloud SQL to synchronize the data to the replica.
✓
Correct Answer: D
Create an external replica, and use Cloud SQL to synchronize the data to the replica.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.