Google Cloud Certified - Professional Cloud Database Engineer Professional-Cloud-Database-Engineer Question # 32 Topic 4 Discussion

Google Cloud Certified - Professional Cloud Database Engineer Professional-Cloud-Database-Engineer Question # 32 Topic 4 Discussion

Professional-Cloud-Database-Engineer Exam Topic 4 Question 32 Discussion:
Question #: 32
Topic #: 4

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?


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.


Get Premium Professional-Cloud-Database-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.