Question 22 of 139
Single answerYou 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?
ACreate and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
BCreate two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to
another.
✓CCreate a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a
new instance.
DCreate 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
Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
▥
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.