Practice Test 2 | Google Cloud Certified Professional Cloud Architect | Dumps | Mock Test
You have a mission-critical database running on an instance on Google Compute Engine. You need to automate a database backup once per day to another disk. The database must remain fully operational and functional and can have no downtime. How can you best perform an automated backup of the database with minimal downtime and maximum reliability?
A. Use a cron job to schedule your application to backup the database to another persistent disk.
B. Use a cron job to schedule a disk snapshot once per day.
C. Write the database to two different disk locations simultaneously, then schedule a snapshot of the secondary disk, which will allow the primary disk to continue running.
D. Use the automated snapshot service on Compute Engine to schedule a snapshot.
Correct answer A
To both minimize costs (don’t want extra disks) and minimize downtime (cannot freeze database). Backing up just the database to another disk using a cron job is the preferred answer. It is also possible to backup the database to a Cloud Storage bucket instead of a disk, which would be cheaper for the same amount of storage.
B and D all have some sort of Database downtime due to the snapshot.
Answer C would be hard to implement and use doubled resources. You’ll also lost the data consistency if you don’t freeze the primary database when you take snapshot on secondary database. Overall, it’s not worthwhile for your efforts for this task when you have better solution like answer A.
Comments are closed, but trackbacks and pingbacks are open.