Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 23

Question

You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance. Cloud Storage provides durable, scalable object storage that is fully managed.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 23