Cloud SQL pricing in GCP - Cheat Sheet & Quick Revision

Recall & Review

beginner

What are the main components that affect Cloud SQL pricing?

The main components are: instance size (CPU and memory), storage amount and type, network usage, and backup storage.

beginner

How does storage type impact Cloud SQL costs?

Using SSD storage costs more than standard HDD storage but offers better performance.

intermediate

Why does network usage affect Cloud SQL pricing?

Data sent out of Cloud SQL to the internet or other regions can incur network egress charges.

intermediate

What is the pricing impact of backups in Cloud SQL?

Backup storage beyond the size of your database is charged separately, so frequent or large backups increase costs.

beginner

How does instance uptime affect Cloud SQL pricing?

You pay for the instance while it is running, so stopping an instance can reduce costs.

Which factor does NOT directly affect Cloud SQL pricing?

A Amount of storage used

B Number of database users

C Instance CPU and memory size

D Network egress traffic

Cloud SQL pricing depends on resources like CPU, memory, storage, and network, not on the number of users.

What type of storage is more expensive but faster in Cloud SQL?

A Standard HDD

B Tape storage

C SSD

D In-memory storage

SSD storage costs more than HDD but provides better performance.

When are network egress charges applied in Cloud SQL?

A When data is sent to the internet or other regions

B When data is sent within the same region

C When data is stored on disk

D When backups are created

Network egress charges apply when data leaves the Cloud SQL region or goes to the internet.

How can you reduce Cloud SQL costs related to instance uptime?

A Stop the instance when not in use

B Use more backups

C Add more users

D Increase storage size

Stopping the instance when not needed stops billing for compute resources.

What happens if your backup storage exceeds your database size in Cloud SQL?

A Backup storage is unlimited and free

B You get free extra storage

C Backups are deleted automatically

D You pay extra for the additional backup storage

Backup storage beyond the database size is charged separately.

Explain the main factors that influence Cloud SQL pricing and how they affect your monthly bill.

Think about what resources you use and how long your database runs.

Describe ways to optimize Cloud SQL costs without sacrificing performance.

Consider balancing cost and performance carefully.