Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can you execute a one-time data migration from an active Cloud SQL for MySQL instance in us-central1 to a new instance in us-east1 while adhering to Google's best practices to reduce performance impact on the source instance?
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.
