Cloud SQL Proxy for secure connections in GCP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start the Cloud SQL Proxy with the correct instance connection name.

GCP

cloud_sql_proxy -instances=[1]=tcp:5432

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

Amy-project:us-central1:my-instance

Bmy-instance:us-central1:my-project

Cus-central1:my-project:my-instance

Dmy-project:my-instance:us-central1

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of project, region, and instance.

Using slashes or dots instead of colons.

The correct format for the instance connection name is project:region:instance.

2fill in blank

medium

Complete the command to specify the credentials file for Cloud SQL Proxy.

GCP

cloud_sql_proxy -instances=my-project:us-central1:my-instance=tcp:5432 -credential_file=[1]

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

A/path/to/key.json

B/path/to/key.txt

C/path/to/key.yaml

D/path/to/key.pem

Attempts:

3 left

💡 Hint

Common Mistakes

Using a text or YAML file instead of JSON.

Using a certificate file (.pem) instead of credentials.

The credentials file for Cloud SQL Proxy must be a JSON key file downloaded from the Google Cloud Console.

3fill in blank

hard

Fix the error in the command to run Cloud SQL Proxy on port 3306.

GCP

cloud_sql_proxy -instances=my-project:us-central1:my-instance=[1]

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

Atcp:3307

Btcp:3306

Cudp:3306

Dhttp:3306

Attempts:

3 left

💡 Hint

Common Mistakes

Using UDP or HTTP protocols instead of TCP.

Using the wrong port number.

Cloud SQL Proxy listens on TCP ports, so the correct prefix is tcp: followed by the port number.

4fill in blank

hard

Fill both blanks to create a command that runs Cloud SQL Proxy with instance connection and logs output to a file.

GCP

cloud_sql_proxy -instances=[1]=tcp:5432 > [2] 2>&1 &

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

Amy-project:us-central1:my-instance

Bproxy.log

Cerror.log

Dmy-instance:us-central1:my-project

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping project and instance in the connection name.

Using a non-log file name for output.

The instance connection name must be in the correct format, and the log file is commonly named proxy.log.

5fill in blank

hard

Fill all three blanks to create a Python dictionary comprehension that maps instance names to their ports if the port is greater than 5000.

GCP

ports = { [1]: [2] for [1], [2] in instances if [2] > 5000 }

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

Ainstance

Bport

Attempts:

3 left

💡 Hint

Common Mistakes

Using different variable names inconsistently.

Using the key variable in the condition instead of the value.

The variable instance is used as the key, and port as the value and in the condition.