Creating a Cloud SQL instance in GCP - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the database version when creating a Cloud SQL instance.

GCP

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

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

AMYSQL_8_0

BPOSTGRES_12

CSQLSERVER_2017_STANDARD

DORACLE_19C

Attempts:

3 left

💡 Hint

Common Mistakes

Using a database version not supported by Cloud SQL.

Leaving the database version blank.

The --database-version flag sets the database engine version. Here, MYSQL_8_0 is a valid Cloud SQL version.

2fill in blank

medium

Complete the command to specify the machine tier for the Cloud SQL instance.

GCP

gcloud sql instances create my-instance --database-version=MYSQL_8_0 --tier=[1] --region=us-central1

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

Adb-custom-2-7680

Bdb-n1-standard-1

Cdb-g1-small

Ddb-f1-micro

Attempts:

3 left

💡 Hint

Common Mistakes

Using a tier that is too large for simple tests.

Using an invalid tier name.

The --tier flag sets the machine type. db-f1-micro is a small, cost-effective tier for testing.

3fill in blank

hard

Fix the error in the command to create a Cloud SQL instance with a specified region.

GCP

gcloud sql instances create my-instance --database-version=MYSQL_8_0 --tier=db-f1-micro --region=[1]

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

Aeurope-west1-c

Bus-central1

Cus-east1-b

Dus-central1-a

Attempts:

3 left

💡 Hint

Common Mistakes

Using a zone name instead of a region name.

Typo in the region name.

The --region flag requires a region name, not a zone. us-central1 is a valid region.

4fill in blank

hard

Fill both blanks to create a Cloud SQL instance with a specific database version and tier.

GCP

gcloud sql instances create my-instance --database-version=[1] --tier=[2] --region=us-central1

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

AMYSQL_5_7

Bdb-n1-standard-1

Cdb-f1-micro

DPOSTGRES_13

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing database versions and tiers incorrectly.

Using a PostgreSQL version with a MySQL tier.

The --database-version is set to MYSQL_5_7 and the --tier is set to db-f1-micro for a small MySQL instance.

5fill in blank

hard

Fill all three blanks to create a Cloud SQL instance with a database version, tier, and region.

GCP

gcloud sql instances create my-instance --database-version=[1] --tier=[2] --region=[3]

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

APOSTGRES_14

Bdb-custom-4-15360

Cus-east1

DMYSQL_8_0

Attempts:

3 left

💡 Hint

Common Mistakes

Using a PostgreSQL version with a MySQL tier.

Using a zone instead of a region.

The command creates a MySQL 8.0 instance with a custom machine type in the us-east1 region.