Creating a Cloud SQL instance in GCP - Quick Revision & Summary

Recall & Review

beginner

What is a Cloud SQL instance in Google Cloud?

A Cloud SQL instance is a managed database service in Google Cloud that lets you run relational databases like MySQL, PostgreSQL, or SQL Server without managing the underlying hardware or software.

beginner

Which command-line tool can you use to create a Cloud SQL instance?

You can use the gcloud command-line tool to create and manage Cloud SQL instances.

beginner

What are the key parameters needed to create a Cloud SQL instance?

You need to specify the instance name, database version (like MySQL 8.0), region, and machine tier (CPU and memory size).

intermediate

Why is it important to choose the right region when creating a Cloud SQL instance?

Choosing a region close to your users reduces latency and can improve performance. It also affects data residency and compliance.

beginner

What is the benefit of using a managed service like Cloud SQL instead of running your own database server?

Cloud SQL handles backups, patching, replication, and scaling automatically, so you can focus on your application instead of managing database infrastructure.

Which database engines can you run on Cloud SQL?

A Oracle, DB2, Sybase

B MongoDB, Cassandra, Redis

C SQLite, MariaDB, Firebase

D MySQL, PostgreSQL, SQL Server

Cloud SQL supports MySQL, PostgreSQL, and SQL Server as managed relational databases.

What is the correct gcloud command to create a MySQL 8.0 Cloud SQL instance named 'my-instance' in region 'us-central1'?

A gcloud sql instances create my-instance --database-version=MYSQL_8_0 --region=us-central1

B gcloud sql create instance my-instance --version=MYSQL8 --location=us-central1

C gcloud sql instances new my-instance --db-version=MYSQL8 --zone=us-central1

D gcloud sql instances deploy my-instance --db=MYSQL8 --region=us-central1

The correct syntax uses 'gcloud sql instances create' with '--database-version' and '--region' flags.

Why should you specify a machine tier when creating a Cloud SQL instance?

A To select the backup schedule

B To set the network bandwidth for your instance

C To define the CPU and memory resources for the database instance

D To choose the database engine version

The machine tier determines the CPU and memory allocated to your Cloud SQL instance.

Which of the following is NOT handled automatically by Cloud SQL?

A Software patching

B Writing application code

C Scaling storage automatically

D Database backups

Cloud SQL manages infrastructure tasks but does not write your application code.

What is a benefit of choosing a Cloud SQL instance region close to your users?

A Lower latency and faster database response

B Cheaper storage costs

C Automatic database schema updates

D Unlimited database size

A nearby region reduces network delay, improving database response times.

Describe the steps to create a Cloud SQL instance using the gcloud command-line tool.

Think about what details you need before running the command.

Explain why using a managed database service like Cloud SQL can save time and effort compared to managing your own database server.

Consider what tasks are handled for you by the service.