Your company runs several databases on a single MySQL instance. They need to take backups of a specific database at regular intervals. The backup activity needs to complete as quickly as possible and cannot be allowed to impact disk performance. How should you configure the storage?
Choose an answer
Tap an option to check your answer.
Correct answer: Mount a Local SSD volume as the backup location. After the backup is complete, use gsutil to move the backup to Google Cloud Storage..
Why this is the answer
Mounting a Local SSD provides extremely high I/O performance, ensuring the backup completes quickly and doesn't impact the primary database's disk performance. After the backup is written to the Local SSD, gsutil can efficiently transfer it to Google Cloud Storage for durable, cost-effective storage. Persistent disk snapshots (option 1) are good for full instance backups but can be slower for specific database backups and might impact performance during the snapshot process. Using gcsfuse (option 3) directly for backups is not recommended for performance-critical operations due to potential latency and throughput limitations. RAID10 with LVM snapshots (option 4) adds complexity and still uses persistent disks, which are slower than Local SSDs for the initial backup write.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed