Google Cloud Professional Cloud Database Engineer — Question 37

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?

Answer options

• A. Use Cloud SQL serverless exports.
• B. Create a read replica, and then use the mysqldump utility to export each table.
• C. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
• D. Use the mysqldump utility on the primary database instance to export the backup.

Correct answer: A

Explanation

The correct answer is A because Cloud SQL serverless exports allow for automated and efficient backups to object storage without additional operational burden. Options B, C, and D involve more manual processes with risks of impacting production workloads, making them less ideal for a 24/7 availability requirement.