Google Cloud Professional Cloud Database Engineer — Question 45

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?

Answer options

• A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
• B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
• C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
• D. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

Correct answer: C

Explanation

The correct answer is C because creating a SQL dump file minimizes disruption to the running instance and allows for a seamless import into the new instance. Options A and B involve real-time data streaming, which could impose additional load on the source instance, while option D requires more manual steps and may not be as efficient or reliable as using a SQL dump.