Google Exam Professional Cloud Database Engineer Topic 8 Question 13 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 13
Topic #: 8

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: A

by Bok at Jan 06, 2023, 05:44 PM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cheryl

14 days ago

I think option B could also work well, creating two Datastream connection profiles seems efficient.

upvoted 0 times

...

Linn

15 days ago

I disagree, I believe option A is better as it involves creating and running a Dataflow job.

upvoted 0 times

...

Rose

18 days ago

I think option C is the best choice because it involves creating a SQL dump file in Cloud Storage.

upvoted 0 times

...