Cloud SQL supported engines (MySQL, PostgreSQL, SQL Server) in GCP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the Cloud SQL engine as MySQL.

GCP

gcloud sql instances create my-instance --database-version=[1]_57

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

APOSTGRES

BORACLE

CMYSQL

DSQLSERVER

Attempts:

3 left

💡 Hint

Common Mistakes

Using unsupported engine names like ORACLE.

Confusing PostgreSQL with MySQL engine names.

The correct engine identifier for MySQL in Cloud SQL is MYSQL.

2fill in blank

medium

Complete the code to specify the Cloud SQL engine as PostgreSQL.

GCP

gcloud sql instances create pg-instance --database-version=[1]_14

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

AMYSQL

BMARIADB

CSQLSERVER

DPOSTGRES

Attempts:

3 left

💡 Hint

Common Mistakes

Using MYSQL or SQLSERVER instead of POSTGRES.

Using unsupported engines like MARIADB.

The correct engine identifier for PostgreSQL in Cloud SQL is POSTGRES.

3fill in blank

hard

Fix the error in the command to create a SQL Server instance.

GCP

gcloud sql instances create sqlserver-instance --database-version=[1]_2019

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

AMYSQL

BSQLSERVER

CPOSTGRES

DMSSQL

Attempts:

3 left

💡 Hint

Common Mistakes

Using MSSQL instead of SQLSERVER.

Using MYSQL or POSTGRES for SQL Server instances.

The correct engine identifier for SQL Server in Cloud SQL is SQLSERVER.

4fill in blank

hard

Fill both blanks to create a Cloud SQL instance with PostgreSQL engine version 13.

GCP

gcloud sql instances create [1] --database-version=[2]_13

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

Apg-instance

BMYSQL

CPOSTGRES

Dsqlserver-instance

Attempts:

3 left

💡 Hint

Common Mistakes

Using MYSQL as engine for PostgreSQL instance.

Using unrelated instance names.

The instance name can be pg-instance and the engine identifier for PostgreSQL is POSTGRES.

5fill in blank

hard

Fill all three blanks to create a Cloud SQL instance named 'sqlserver-prod' with SQL Server 2017 engine.

GCP

gcloud sql instances create [1] --database-version=[2]_[3]

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

Asqlserver-prod

BSQLSERVER

C2017

DPOSTGRES

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing engine names like POSTGRES with SQL Server instance.

Using incorrect version numbers.

The instance name is sqlserver-prod, engine is SQLSERVER, and version is 2017.