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

Wai

2 months ago

Option C is the way to go, but I gotta say, Option D with the CSV file is like trying to use a sledgehammer to crack a walnut. Sometimes, the simplest solutions are the best.

upvoted 0 times

Peggie

27 days ago

Yeah, Option D seems like overkill for this task. Keeping it simple with Option C is the way to go.

upvoted 0 times

...

Yesenia

1 months ago

I agree, using a SQL dump file in Cloud Storage is the recommended practice.

upvoted 0 times

...

Erasmo

1 months ago

Option C is definitely the most efficient way to migrate the data.

upvoted 0 times

...

Belen

3 months ago

Whoa, did someone say 'SQL dump'? That's my jam! Option C all the way, baby. No need to get fancy when a good old-fashioned SQL file will do the trick.

upvoted 0 times

Lindsey

1 months ago

Yeah, no need to overcomplicate things. SQL dump file is the way to go for sure.

upvoted 0 times

...

Royal

2 months ago

I agree, keeping it simple with a SQL dump file is the best approach.

upvoted 0 times

...

Vinnie

2 months ago

Option C all the way! SQL dump file in Cloud Storage is the way to go.

upvoted 0 times

...

Doug

3 months ago

Hold up, Option D with the CSV file? That's a bold move, but I respect the creativity. Still, the SQL dump in Option C seems like the safest bet.

upvoted 0 times

Jeanice

1 months ago

Yeah, Option C is the way to go for a one-time migration like this.

upvoted 0 times

...

Lindy

2 months ago

I agree, Option C with the SQL dump seems safer and more reliable.

upvoted 0 times

...

Melvin

2 months ago

Option D with the CSV file is risky but could work.

upvoted 0 times

...

Roy

3 months ago

Hmm, I'm not sure about Dataflow or Datastream for this use case. Seems like overkill. The SQL dump file in Option C is probably the simplest and most reliable solution.

upvoted 0 times

...

Alfred

3 months ago

Option C looks like the way to go. Using a SQL dump file and then importing it is a straightforward approach that should minimize impact on the running instance.

upvoted 0 times

...