Why managed databases matter in GCP - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a managed SQL instance in Google Cloud.

GCP

gcloud sql instances create [1] --database-version=POSTGRES_14 --tier=db-f1-micro --region=us-central1

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

Amy-instance

Bcreate-instance

Csql-instance

Ddatabase-1

Attempts:

3 left

💡 Hint

Common Mistakes

Using commands instead of instance name

Including spaces in the name

The instance name must be a valid identifier. 'my-instance' is a typical example.

2fill in blank

medium

Complete the code to connect to a managed database using the Cloud SQL Proxy.

GCP

./cloud_sql_proxy -instances=[1]=tcp:5432

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

Aproject:region:instance

Bproject-instance-region

Cinstance:project:region

Dregion:project:instance

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing order of project, region, and instance

Using dashes instead of colons

The format for Cloud SQL Proxy instances is project:region:instance.

3fill in blank

hard

Fix the error in the command to create a Cloud SQL user with a password.

GCP

gcloud sql users create [1] --instance=my-instance --password='securePass123'

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

Aadmin

Buser1

Cmy-instance

Dpassword

Attempts:

3 left

💡 Hint

Common Mistakes

Using instance name as user

Using reserved words as user name

The username should be a valid user name like 'user1'. 'my-instance' is the instance name, not a user.

4fill in blank

hard

Fill both blanks to configure automatic backups and high availability for a managed database instance.

GCP

gcloud sql instances patch my-instance --backup-start-time=[1] --availability-type=[2]

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

A03:00

B07:00

CREGIONAL

DZONAL

Attempts:

3 left

💡 Hint

Common Mistakes

Using invalid time format

Choosing 'ZONAL' when high availability is needed

Backups typically start early morning like 03:00. 'REGIONAL' enables high availability across zones.

5fill in blank

hard

Fill all three blanks to create a read replica for a Cloud SQL instance with the correct flags.

GCP

gcloud sql instances create [1] --master-instance-name=[2] --region=[3]

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

Amy-replica

Bmy-instance

Cus-central1

Deurope-west1

Attempts:

3 left

💡 Hint

Common Mistakes

Using same name for replica and master

Choosing wrong region format

The replica name is 'my-replica', the master instance is 'my-instance', and the region is 'us-central1'.