Exam Professional Cloud Database Engineer topic 1 question 23 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 23
Topic #: 1

[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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by GCP72 at Dec. 24, 2022, 8:23 a.m.

Comments

Submit Cancel

PKookNN

1 year ago

Selected Answer: C

C is simple and works

upvoted 1 times

...

dynamic_dba

1 year, 11 months ago

C. The only way to minimize performance impact of running an export on a Cloud SQL instance is to use a serverless export. The fact that no data synchronization is needed since it’s a one off eliminates every option apart from C.

upvoted 3 times

...