Professional-Cloud-Architect Exam Dumps | Your company runs several databases on a single MySQL instance. They need to take backups of a specific

<< Prev Question Next Question >>

Question 83/89

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?

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 gcsfuse 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.

Recent Comments (The most recent comments are at the top.)

eloquent - Jan 21, 2023

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.
"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."
https://cloud.google.com/compute/docs/instances/sql-server/best-practices#backing_up

Question 83/89

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File