Backup and restore in GCP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Cloud Storage bucket for backups.

GCP

gcloud storage buckets create [1] --location=us-central1

Drag options to blanks, or click blank then click option'

Abackup-bucket-123

Brestore-bucket

Cmy-backup-bucket

Dtemp-bucket

Attempts:

3 left

💡 Hint

Common Mistakes

Using uppercase letters in bucket names

Choosing a name that is already taken

The bucket name must be globally unique and descriptive. "backup-bucket-123" is a valid example.

2fill in blank

medium

Complete the command to create a backup of a Cloud SQL instance.

GCP

gcloud sql backups create --instance=[1]

Drag options to blanks, or click blank then click option'

Abackup-instance

Bmy-instance

Csql-instance-01

Dtest-instance

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong or non-existing instance name

Confusing backup names with instance names

The instance name must match the Cloud SQL instance you want to back up. "sql-instance-01" is a typical instance name.

3fill in blank

hard

Fix the error in the command to restore a Cloud SQL instance from a backup.

GCP

gcloud sql instances restore-backup [1] --backup-id=12345

Drag options to blanks, or click blank then click option'

A--instance=sql-instance-01

Binstance=sql-instance-01

C--backup-instance=sql-instance-01

Dsql-instance-01

Attempts:

3 left

💡 Hint

Common Mistakes

Using --instance flag which is not accepted here

Adding incorrect flags before the instance name

The instance name should be provided as a positional argument without flags in this command.

4fill in blank

hard

Fill both blanks to configure automated backups for a Cloud SQL instance.

GCP

gcloud sql instances patch [1] --backup-start-time=[2]

Drag options to blanks, or click blank then click option'

Asql-instance-02

Bsql-instance-03

C03:00

D22:00

Attempts:

3 left

💡 Hint

Common Mistakes

Using invalid time formats

Using wrong instance names

Use the correct instance name and specify the backup start time in 24-hour format.

5fill in blank

hard

Fill all three blanks to create a backup export of a Cloud SQL database to Cloud Storage.

GCP

gcloud sql export sql [1] gs://[2]/[3].sql --database=mydb

Drag options to blanks, or click blank then click option'

Asql-instance-04

Bbackup-bucket-123

Cmydb-backup-2024

Dsql-instance-05

Attempts:

3 left

💡 Hint

Common Mistakes

Using a bucket that does not exist

Using incorrect instance names

Not providing a filename for the export

Specify the correct instance name, the bucket name, and a descriptive filename for the export.