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

Haydee

8 days ago

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

upvoted 0 times

...

Paul

10 days ago

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

upvoted 0 times

...

Ora

14 days ago

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

upvoted 0 times

...

Erin

16 days ago

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

upvoted 0 times

Precious

3 days ago

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

upvoted 0 times

...

Paul

18 days ago

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

upvoted 0 times

...