Google Cloud Professional Cloud Architect — Question 31

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?

Answer options

• A. Configure a cron job to use the gcloud tool to take regular backups using persistent disk snapshots.
• B. Mount a Local SSD volume as the backup location. After the backup is complete, use gsutil to move the backup to Google Cloud Storage.
• C. Use gcsfise to mount a Google Cloud Storage bucket as a volume directly on the instance and write backups to the mounted location using mysqldump.
• D. Mount additional persistent disk volumes onto each virtual machine (VM) instance in a RAID10 array and use LVM to create snapshots to send to Cloud Storage

Correct answer: B

Explanation

Option B is correct because using a Local SSD for backups ensures high-speed access while minimizing the impact on disk performance. Other options either involve slower backup methods or could lead to performance degradation due to the nature of disk usage and network transfers.