Professional-Cloud-Database-Engineer Exam Dumps : Google Cloud Certified - Professional Cloud Database Engineer

Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

Create a read replica in another region, and promote the read replica if a failure occurs.

Enable high availability (HA) for the database to make it regional.

Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.

Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.

Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.

Create an external replica, and use Cloud SQL to synchronize the data to the replica.

Identify and optimize slow running queries, or set parallel replication flags.

Stop all running queries, and re-create the replicas.

Edit the primary instance to upgrade to a larger disk, and increase vCPU count.

Edit the primary instance to add additional memory.