Google Exam Professional Cloud Database Engineer Topic 4 Question 29 Discussion

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

Question #: 29
Topic #: 4

[All Professional Cloud Database Engineer Questions]

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

AUse Cloud SQL serverless exports.

BCreate a read replica, and then use the mysqldump utility to export each table.

CClone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

DUse the mysqldump utility on the primary database instance to export the backup.

Show Suggested Answer

Suggested Answer: C

by Kristel at Apr 10, 2024, 03:20 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

Lourdes

1 months ago

Hey, at least it's not a 50 TB database, right? That would be a real backup nightmare!

upvoted 0 times

Ona

11 days ago

C) Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

upvoted 0 times

...

Nu

14 days ago

B) Create a read replica, and then use the mysqldump utility to export each table.

upvoted 0 times

...

Vincent

21 days ago

A) Use Cloud SQL serverless exports.

upvoted 0 times

...

Jamal

2 months ago

D) Directly mysqldump the primary database? Yikes, that could really impact my production workloads. Not a fan of that idea.

upvoted 0 times

Mitzie

15 days ago

C) Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

upvoted 0 times

...

Curtis

25 days ago

B) Create a read replica, and then use the mysqldump utility to export each table.

upvoted 0 times

...

Detra

1 months ago

A) Use Cloud SQL serverless exports.

upvoted 0 times

...

Judy

2 months ago

C) Cloning the instance and then mysqldump? Seems a bit overkill for a 5 TB database. I'll pass on that one.

upvoted 0 times

Giuseppe

10 days ago

C) Cloning the instance and then mysqldump? Seems a bit overkill for a 5 TB database. I'll pass on that one.

upvoted 0 times

...

Laurel

18 days ago

B) Create a read replica, and then use the mysqldump utility to export each table.

upvoted 0 times

...

Vi

27 days ago

A) Use Cloud SQL serverless exports.

upvoted 0 times

...

Haydee

2 months ago

B) Creating a read replica and using mysqldump sounds like a good plan. Keeps the production workload safe.

upvoted 0 times

Nelida

4 days ago

User 4: Using mysqldump on the primary database instance seems like a risky option for such a critical database.

upvoted 0 times

...

Mirta

6 days ago

User 3: Cloning the Cloud SQL instance and then using mysqldump to export the data could work too.

upvoted 0 times

...

Ty

7 days ago

User 2: Creating a read replica and using mysqldump sounds like a good plan. Keeps the production workload safe.

upvoted 0 times

...

Carrol

8 days ago

User 1: I think using Cloud SQL serverless exports would be the best option.

upvoted 0 times

...

Denae

1 months ago

B) Creating a read replica and using mysqldump sounds like a good plan. Keeps the production workload safe.

upvoted 0 times

...

Karima

2 months ago

A) Use Cloud SQL serverless exports.

upvoted 0 times

...

Paul

2 months ago

That's a good point, but I still think serverless exports are more efficient in this scenario.

upvoted 0 times

...

Ora

2 months ago

I disagree, I believe option C is better because cloning the instance ensures data consistency.

upvoted 0 times

...

Erin

2 months ago

A) Cloud SQL serverless exports seem like the easiest option. Minimal operational overhead is exactly what I need!

upvoted 0 times

Jerry

2 months ago

C) Cloning the instance and using mysqldump could work as well, but it might be more complex.

upvoted 0 times

...

Jospeh

2 months ago

A) True, but I prefer the simplicity of Cloud SQL serverless exports.

upvoted 0 times

...

France

2 months ago

B) Creating a read replica and using mysqldump sounds like a good option too.

upvoted 0 times

...

Precious

2 months ago

A) Cloud SQL serverless exports seem like the easiest option. Minimal operational overhead is exactly what I need!

upvoted 0 times

...

Paul

2 months ago

I think option A is the best choice for minimal operational overhead.

upvoted 0 times

...