Topic 1 Question 20
Your 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?
Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
Create an external replica, and use Cloud SQL to synchronize the data to the replica.
ユーザの投票
コメント(11)
Correct answer is D: Create cloudsql replica of on-prem server and promote with almost-no downtime by pointing app to cloudsql. mysqldump is heavy and time-consuming operation (even though if you run it on on-prem read-replica, it will be identical to migrating to cloudsql using managed database migration service.
👍 4SidsA2023/02/11- 正解だと思う選択肢: B👍 3range90052022/12/21
D create a read replica on cloud then promote it
👍 3SandyZA2023/01/06
シャッフルモード