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

Restore the Cloud SQL instance from the automatic backups in region 3.

Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status usingpg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .

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.

Use Firestore and ensure that the PersistenceEnabled option is set to true.

Use Memorystore for Memcached.

Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.