Cloud SQL pricing in GCP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the Cloud SQL instance tier for pricing calculation.

GCP

instance_config = {"tier": "[1]"}

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

Adb-n1-standard-1

Bdb-custom-2-7680

Cdb-f1-micro

Ddb-n2-highmem-4

Attempts:

3 left

💡 Hint

Common Mistakes

Using a tier name that is not valid or does not exist.

Confusing custom machine types with predefined tiers.

The tier db-f1-micro is a valid Cloud SQL instance tier used for pricing and configuration.

2fill in blank

medium

Complete the code to set the storage type for Cloud SQL pricing.

GCP

storage_config = {"storageType": "[1]"}

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

ARAM

BSSD

CNVMe

DHDD

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing unsupported storage types like NVMe or RAM.

Confusing storage type with instance tier.

The storage type SSD is commonly used for Cloud SQL and affects pricing.

3fill in blank

hard

Fix the error in the code to correctly calculate the monthly cost for a Cloud SQL instance with 100 GB storage.

GCP

monthly_cost = instance_price_per_hour * 24 * 30 + [1] * storage_price_per_gb

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

A1000

B10

C1

D100

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1000 instead of 100, which overestimates cost.

Using 10 or 1, which underestimates cost.

The storage size is 100 GB, so the multiplier must be 100 to calculate storage cost correctly.

4fill in blank

hard

Fill both blanks to define a Cloud SQL instance with 2 vCPUs and 7.5 GB RAM for pricing estimation.

GCP

instance_config = {"vCPU": [1], "memoryGb": [2]

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

A2

B4

C7.5

D15

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping vCPU and memory values.

Using incorrect numbers not matching the instance specs.

The instance has 2 vCPUs and 7.5 GB RAM, which are used for pricing calculations.

5fill in blank

hard

Fill all three blanks to calculate total monthly cost including instance, storage, and backup costs.

GCP

total_cost = ([1] * hours_per_month) + (storage_gb * [2]) + (backup_gb * [3])

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

Ainstance_price_per_hour

Bstorage_price_per_gb

Cbackup_price_per_gb

Dnetwork_price_per_gb

Attempts:

3 left

💡 Hint

Common Mistakes

Including network price instead of backup price.

Mixing up storage and backup price variables.

The total cost includes instance hourly price, storage price per GB, and backup price per GB.