Your Company Runs Several Databases on a Single MySQL Instance

question 85

Multiple Choice

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

---

Definitions:

Antipyretic

Drugs or substances used to reduce or prevent fever.

Analgesic

A type of medication used to reduce or eliminate pain.

Antibiotic

A substance used to kill or inhibit the growth of bacteria and other microorganisms.

Anticholinergic

Refers to substances that block the action of acetylcholine, a neurotransmitter, which can affect various bodily functions including muscle movement and bodily secretions.