Answer-first summary for fast verification
Answer: Use Cloud SQL serverless exports.
The question involves selecting the best method to backup a large Cloud SQL for MySQL instance with minimal operational overhead and risk to production workloads. Option A, using Cloud SQL serverless exports, is the most efficient and least risky method as it is managed by Google Cloud, reducing operational overhead and ensuring backups are performed without impacting the production database. Options B, C, and D involve manual processes or creating replicas/clones, which introduce additional operational overhead and potential risks to production workloads. Therefore, the correct answer is A.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you efficiently store backups for a 24/7 available 5 TB Cloud SQL for MySQL database on object storage with minimal operational overhead and no impact on production workloads?
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.
No comments yet.