Google Professional Cloud Database Engineer Exam - 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

Dino

4 months ago

Wait, can you really use a SQL dump for this? Seems risky!

upvoted 0 times

...

Evette

4 months ago

Definitely going with C, it's the safest bet!

upvoted 0 times

...

Denise

4 months ago

A sounds interesting, but isn't Dataflow overkill for this?

upvoted 0 times

...

Sharen

4 months ago

I think B could work too, but not sure about performance.

upvoted 0 times

...

Titus

4 months ago

Option C is the most reliable method.

upvoted 0 times

...

Carmelina

5 months ago

I vaguely remember something about using CSV files for data export, but I’m not confident it’s the right approach for migrating between regions.

upvoted 0 times

...

Fletcher

5 months ago

I feel like the Dataflow job option could be efficient, but I can't recall if it’s recommended for this specific scenario.

upvoted 0 times

...

Oretha

5 months ago

I think creating a SQL dump file is a common practice we went over, but I’m not clear on how it minimizes performance impact.

upvoted 0 times

...

Garry

5 months ago

I remember we discussed using Datastream for real-time data migration in class, but I'm not sure if it's the best option for a one-time migration.

upvoted 0 times

...

Pansy

5 months ago

Hmm, this looks like a tricky one. I'll need to think it through carefully.

upvoted 0 times

...

Eulah

5 months ago

Wait, is the exponent supposed to be applied to the whole expression or just the 3? I'm a little confused on how to approach this.

upvoted 0 times

...

Wai

10 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

8 months 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

8 months ago

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

upvoted 0 times

...

Erasmo

9 months ago

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

upvoted 0 times

...

Belen

10 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

8 months ago

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

upvoted 0 times

...

Royal

9 months ago

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

upvoted 0 times

...

Vinnie

9 months ago

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

upvoted 0 times

...

Doug

10 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

9 months ago

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

upvoted 0 times

...

Lindy

9 months ago

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

upvoted 0 times

...

Melvin

9 months ago

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

upvoted 0 times

...

Roy

10 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

10 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

...