<< Prev Question Next Question >>

Question 46/70

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?

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

GK - Oct 07, 2018

Snapshots are not backups, and should not be used in lieu of a backup strategy. So A and B are false.

I would probably go with C given testtaker&#39;s comment about lack of production support for gcsfuse .

Ross - Sep 12, 2018

answer is B. Taking snapshot is fast and does not have impact on performance

Ross - Aug 18, 2018

https://cloud.google.com/sql/docs/mysql/backup-recovery/backups#where_backups_are_stored

why do we need to provide a backup device/location for Cloud SQL backup?

Stevie P - Jul 17, 2018

Agree with testtaker. The below from GCP documentation

Backing up
Best practice: Have a plan for backups and perform backups regularly.

Ola Hallengren&#39;s site provides a good starting point for understanding how to implement a solid backup and maintenance plan.

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.

testtaker - Jun 16, 2018

C
It is best practice to have the DB app perform the backup to an alternative/temp and fast block storage device (local SSD).
Cloud Storage FUSE is only community-supported, which makes it not ideal for production workloads.
https://cloud.google.com/storage/docs/gcs-fuse

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (70q)
2 commentQuestion 1: For this question, refer to the JencoMart case study. JencoM...
6 commentQuestion 2: You want to enable your running Google Container Engine clus...
10 commentQuestion 3: Your application needs to process credit card transactions. ...
4 commentQuestion 4: For this question refer to the TerramEarth case study Operat...
2 commentQuestion 5: For this question, refer to the TerramEarth case study Your ...
3 commentQuestion 6: You want to make a copy of a production Linux virtual machin...
10 commentQuestion 7: For this question, refer to the Dress4Win case study. As par...
6 commentQuestion 8: Your company just finished a rapid lift and shift to Google ...
7 commentQuestion 9: Your solution is producing performance bugs in production th...
6 commentQuestion 10: Your organization requires that metrics from all application...
4 commentQuestion 11: You are creating a solution to remove backup files older tha...
2 commentQuestion 12: Your organization has a 3-tier web application deployed in t...
7 commentQuestion 13: Your company's test suite is a custom C++ application that r...
1 commentQuestion 14: For this question, refer to the TerramEarth case study. Terr...
5 commentQuestion 15: A news teed web service has the following code running on Go...
10 commentQuestion 16: For this question, refer to the JencoMart case study. JencoM...
8 commentQuestion 17: For this question, refer to the Mountkirk Games case study. ...
4 commentQuestion 18: A lead engineer wrote a custom tool that deploys virtual mac...
Question 19: You want to optimize the performance of an accurate, real-ti...
5 commentQuestion 20: For this question, refer to the TerramEarth case study. To s...
8 commentQuestion 21: You are designing a large distributed application with 30 mi...
3 commentQuestion 22: For this question, refer to the JencoMart case study. JencoM...
Question 23: For this question, refer to the Dress4Win case study. You wa...
3 commentQuestion 24: One of your primary business objectives is being able to tru...
3 commentQuestion 25: Your company places a high value on being responsive and mee...
4 commentQuestion 26: For this question, refer to the Mountkirk Games case study. ...
2 commentQuestion 27: Your development team has installed a new Linux kernel modul...
2 commentQuestion 28: You have created several preemptible Linux virtual machine i...
2 commentQuestion 29: For this question, refer to the Dress4Win case study. Dress4...
4 commentQuestion 30: The application reliability team at your company has added a...
1 commentQuestion 31: For this question, refer to the Mountkirk Games case study. ...
5 commentQuestion 32: For this question, refer to the TerramEarth case study. Terr...
6 commentQuestion 33: For this question, refer to the TerramEarth case study. Terr...
5 commentQuestion 34: For this question, refer to the Dress4Win case study. Dress4...
2 commentQuestion 35: Your company's user-feedback portal comprises a standard LAM...
Question 36: You need to reduce the number of unplanned rollbacks of erro...
1 commentQuestion 37: Your company wants to try out the cloud with low risk. They ...
3 commentQuestion 38: For this question, refer to the Dress4Win case study. The Dr...
1 commentQuestion 39: Your company plans to migrate a multi-petabyte data set to t...
8 commentQuestion 40: For this question, refer to the JencoMart case study A few d...
6 commentQuestion 41: A development manager is building a new application He asks ...
1 commentQuestion 42: You set up an autoscaling instance group to serve web traffi...
13 commentQuestion 43: For this question, refer to the TerramEarth case study. Terr...
4 commentQuestion 44: To reduce costs, the Director of Engineering has required al...
2 commentQuestion 45: During a high traffic portion of the day, one of your relati...
5 commentQuestion 46: Your company runs several databases on a single MySQL instan...
Question 47: You deploy your custom Java application to Google App Engine...
4 commentQuestion 48: The database administration team has asked you to help them ...
3 commentQuestion 49: For this question, refer to the JencoMart case study. The Je...
6 commentQuestion 50: You write a Python script to connect to Google BigQuery from...
7 commentQuestion 51: For this question, refer to the Mountkirk Games case study M...
Question 52: Your company has successfully migrated to the cloud and want...
2 commentQuestion 53: A lead software engineer tells you that his new application ...
1 commentQuestion 54: For this question, refer to the Dress4Win case study. As par...
2 commentQuestion 55: For this question, refer to the JencoMart case study. JencoM...
4 commentQuestion 56: Your customer is receiving reports that their recently updat...
10 commentQuestion 57: Your company has decided to build a backup replica of their ...
Question 58: Your marketing department wants to send out a promotional em...
Question 59: Your company is forecasting a sharp increase in the number a...
8 commentQuestion 60: You have been asked to select the storage system for the cli...
Question 61: Your company wants to track whether someone is present in a ...
3 commentQuestion 62: A small number of API requests to your microservices-based a...
Question 63: Your company's test suite is a custom C++ application that r...
7 commentQuestion 64: You are helping the QA team to roll out a new load-testing t...
7 commentQuestion 65: An application development team believes their current loggi...
4 commentQuestion 66: For this question, refer to the Mountkirk Games case study. ...
5 commentQuestion 67: For this question, refer to the Dress4Win case study. Dress4...
5 commentQuestion 68: For this question, refer to the JencoMart case study. The mi...
7 commentQuestion 69: One of the developers on your team deployed their applicatio...
7 commentQuestion 70: Your customer is moving an existing corporate application to...