Google Professional Cloud Database Engineer Exam Practice Test Instant Access

Question 1

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?

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

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

CCheck '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.

DCheck 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 .

Answer : C

https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery

Question 2

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

ACreate a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

BCreate a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

CUse the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

DShut down your existing Cloud SQL for MySQL instance, and enable HA.

Answer : C

Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.

The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.

By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.

Question 3

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

ACreate one regional Cloud SQL instance with a read replica in another region.

BCreate one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

CCreate two read-write Cloud SQL instances in two different zones with a standby instance in another region.

DCreate two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Answer : B

This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover.According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure.If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.

Question 4

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

AView Cloud SQL operations to view historical query information.

BWhite a Logs Explorer query to identify database queries with high execution times.

CReview application logs to identify database calls.

DUse the Query Insights dashboard to identify high execution times.

Answer : D

A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone's persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.

Question 5

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

ABring DB-1 back online.

BDelete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

CDelete DB-2 so that DB-1 automatically reverts to the primary instance.

DCreate DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Answer : D

If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover. https://cloud.google.com/sql/docs/mysql/high-availability#failback

Question 6

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

AShut down and restart each application.

BWrite a utility to scan database query logs.

CWrite a utility to scan application logs.

DUse query tags to add application-centric database monitoring.

Answer : D

https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags

Question 7

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

ASet the automated backups to occur every other day to lower the frequency of backups.

BChange the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

CSelect a different region to store your backups.

DReduce the number of automated backups that are retained to two (2).

Answer : D

By default, for each instance, Cloud SQL retains seven automated backups, in addition to on-demand backups. You can configure how many automated backups to retain (from 1 to 365). We charge a lower rate for backup storage than for other types of instances. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups