Review Questions

You can find the answers in the Appendix.

1. Cloud SQL is a fully managed relational database service, but database administrators still have to perform some tasks. Which of the following tasks do Cloud SQL users need to perform?

   1. Applying security patches
   2. Performing regularly scheduled backups
   3. Creating databases
   4. Tuning the operating system to optimize Cloud SQL performance

2. Which of the following commands is used to create a backup of a Cloud SQL database?

   1. gcloud sql backups create
   2. gsutil sql backups create
   3. gcloud sql create backups
   4. gcloud sql backups export

3. Which of the following commands will run an automatic backup at 3:00 a.m. on an instance called ace-exam-mysql?

   1. gcloud sql instances patch ace-exam-mysql --backup-start-time 03:00
   2. gcloud sql databases patch ace-exam-mysql –-backup-start-time 03:00
   3. cbt sql instances patch ace-exam-mysql -–backup-start-time 03:00
   4. bq gcloud sql instances patch ace-exam-mysql -–backup-start-time 03:00
   ...