Google Professional-Cloud-Database-Engineer Exam Practice Test Instant Access

Question 1

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?

AIssue a rollback, and download your server certificate.

BCreate a new client certificate, and download it.

CCreate a new server certificate, and download it.

DReset your SSL configuration, and download your server certificate.

Answer : C

https://cloud.google.com/sql/docs/sqlserver/configure-ssl-instance#server-certs

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 migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:

PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.

MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.

You want to set up the environment with minimal administrative effort. What should you do?

ASet up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.

BSet up different organizations for each database type, and apply policy constraints at the organization level.

CSet up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.

DSet up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

Answer : D

Question 7

Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

AMigrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.

BMigrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.

CMigrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.

DMigrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.

Answer : B

https://www.actifio.com/solutions/cloud/google/

Google Professional Cloud Database Engineer Exam Practice Test