PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #31
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 y
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Question
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?
Options
- 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.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.