Cloud SQL supported engines (MySQL, PostgreSQL, SQL Server) in GCP - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Cloud SQL in Google Cloud Platform?

Cloud SQL is a fully managed database service that lets you run relational databases in the cloud without managing the underlying infrastructure.

beginner

Which database engines are supported by Cloud SQL?

Cloud SQL supports MySQL, PostgreSQL, and SQL Server database engines.

intermediate

Name one key feature of Cloud SQL for MySQL.

Cloud SQL for MySQL offers automatic backups, replication, and high availability to keep your data safe and accessible.

intermediate

What advantage does Cloud SQL for PostgreSQL provide?

It supports advanced PostgreSQL features like JSONB data type and PostGIS for geographic data, making it powerful for complex applications.

intermediate

Why would you choose Cloud SQL for SQL Server?

Cloud SQL for SQL Server allows you to run Microsoft SQL Server workloads in the cloud with managed backups, patching, and scaling.

Which of the following is NOT a supported engine in Cloud SQL?

A Oracle

B PostgreSQL

C MySQL

D SQL Server

Cloud SQL supports MySQL, PostgreSQL, and SQL Server, but not Oracle.

Cloud SQL automatically manages which of the following for supported engines?

A Hardware repairs

B Backups and patching

C Writing application code

D User interface design

Cloud SQL handles backups, patching, and maintenance tasks automatically.

Which Cloud SQL engine supports PostGIS for geographic data?

A PostgreSQL

B MySQL

C SQL Server

D All of the above

PostgreSQL supports PostGIS, an extension for geographic data.

If you want to run Microsoft SQL Server in Cloud SQL, what benefit do you get?

A Manual backups only

B Only local hosting

C Managed backups and scaling

D No support for SQL Server

Cloud SQL for SQL Server provides managed backups, patching, and scaling.

Which Cloud SQL engine is best known for its JSONB data type support?

A None

B MySQL

C SQL Server

D PostgreSQL

PostgreSQL supports the JSONB data type for efficient JSON storage.

List the three database engines supported by Cloud SQL and one key feature of each.

Think about the main engines and what makes each unique in Cloud SQL.

Explain why using Cloud SQL can be beneficial compared to managing your own database servers.

Consider the tasks Cloud SQL automates for you.