Final Exam: Working with Google Cloud SQL

WHAT YOU WILL LEARN

• 

  Recognize the properties of cloud databases and what makes them different from on-premises systems
  

  recall the benefits of cloud-hosted databases and the features which make them powerful storage solutions
  

  delineate the factors to consider when picking the best database for a particular use case
  

  recognize the benefits of cloud sql
  

  outline how high availability works in cloud sql
  

  provision a new project on google cloud platform (gp) where a cloud sql instance can be set up
  

  use the google cloud console and cli to create a database and user
  

  configure a cloud sql instance to allow connections from external sources
  

  enforce ssl connections for a cloud sql instance and connect from a client using certificates
  

  prevent modifications on a cloud sql instance using database flags
• 

  use the google cloud cli to set labels for a cloud sql instance
  

  set up a cloud sql auth proxy and use it to connect to an instance from a client
  

  create and configure a cloud sql instance with a postgresql engine
  

  create and configure a cloud sql instance with a sql server engine
  

  set up a cloud sql auth proxy to connect to a sql server instance on cloud sql
  

  set up a cloud sql instance for high availability and set a window for automated backups
  

  provision a read replica for a cloud sql instance and test a failover process
  

  recognize how read replicas can be disconnected from a cloud sql instance
  

  generate a backup of a cloud sql instance on-demand and use it to recover to a previous state of the database
  

  configure a migration job to migrate from a mysql server on a vm to a cloud sql for mysql instance