nerdexam
Google

PROFESSIONAL-CLOUD-ARCHITECT · Question #19

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…

The correct answer is B. Mount a Local SSD volume as the backup location. After the backup is complete, use gsutil to. https://cloud.google.com/compute/docs/instances/sql-server/best-practices#backing_up When taking regular database backups, be careful not to consume too many persistent disk IOPS. Use the local SSD to stage your backups and then push them to a Cloud Storage bucket.

Submitted by femi9· Mar 30, 2026Managing and provisioning cloud solution infrastructure

Question

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?

Options

  • AConfigure a cron job to use the gcloud tool to take regular backups using persistent disk
  • BMount a Local SSD volume as the backup location. After the backup is complete, use gsutil to
  • CUse gcsfuse to mount a Google Cloud Storage bucket as a volume directly on the instance and
  • DMount additional persistent disk volumes onto each virtual machine (VM) instance in a RAID10

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    75% (27)
  • C
    14% (5)
  • D
    8% (3)

Explanation

https://cloud.google.com/compute/docs/instances/sql-server/best-practices#backing_up When taking regular database backups, be careful not to consume too many persistent disk IOPS. Use the local SSD to stage your backups and then push them to a Cloud Storage bucket.

Topics

#Local SSD#database backup#MySQL#storage performance

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-ARCHITECT Practice