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

Create secondary indexes on the replica.

Create additional read replicas, and partition your analytics users to use different read replicas.

Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.

Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.

Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

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 .