Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
Professional Cloud Database Engineer
Free trial
Verified
Question 26
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
- A: Restore the Cloud SQL instance from the automatic backups in region 3.
- B: Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
- C: Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
- D: 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 .
Question 27
You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?
- A: Issue a rollback, and download your server certificate.
- B: Create a new client certificate, and download it.
- C: Create a new server certificate, and download it.
- D: Reset your SSL configuration, and download your server certificate.
Question 28
Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?
- A: Migrate the databases to Cloud Spanner.
- B: Migrate the databases to Cloud SQL, and enable a standby database.
- C: Migrate the databases to Compute Engine using regional persistent disks.
- D: Migrate the databases to Bare Metal Solution for Oracle.
That’s the end of your free questions
You’ve reached the preview limit for Professional Cloud Database EngineerConsider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!