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 .

Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

Use Cloud Composer to execute a select * from table(s) query and export results.

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.