Question-38: You have a Wealth Tracking programme that is being installed for each individual bank independently, and in order to facilitate this process, you have established many databases under a single instance of MySQL. They are required to perform backups of a certain database at predetermined time periods. It is essential that the backup process be finished as fast as possible, and any potential effect on disc performance must be avoided at all costs. What kind of configuration should you use for 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
Correct Answer
Get All 340 Questions and Answer for Google Professional Cloud Architect
: 2 Explanation: If you use a tool such as GCFUSE, it will write immediately to GCS, which is advantageous financially because it eliminates the need for intermediate storage. In this particular instance, as soon as possible is essential to comprehending the meaning. The speed at which GCFUSE writes to GCS is significantly slower than the speed at which it writes directly to an added SSD. While it was writing to GCS, it would also execute reads on the production database for a significantly longer period of time. Therefore, writing to the additional SSD would be the solution that I would recommend. Because the data has already been partitioned, offloading from the SSD to the GCS would not have any effect on the database that is currently being used. Only during the process of creating the VM is it possible to create the local SSD. When that is complete, you will be able to mount the disc in the destination path for the mysqldump export. It is recommended that you use gsutil, the supported tool, in order to move the dump to the bucket.