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 designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat

a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

AUse Firestore and ensure that the PersistenceEnabled option is set to true.

BUse Memorystore for Memcached.

CUse Pub/Sub to synchronize the changes from the application to Cloud Spanner.

DUse Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

Answer : A

https://firebase.google.com/docs/firestore/manage-data/enable-offline

Question 7

Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

ADevelop a custom data replication service to send data into BigQuery.

BUse Cloud SQL federated queries.

CUse Database Migration Service to replicate tables into BigQuery.

DUse Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

Answer : D

''Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. Datastream supports change data streaming from Oracle and MySQL databases to Google Cloud Storage (GCS). The service offers streamlined integration with Dataflow templates to power up to date materialized views in BigQuery for analytics, replicate their databases into Cloud SQL or Cloud Spanner for database synchronization, or leverage the event stream directly from GCS to realize event-driven architectures.''