Free Google Professional-Cloud-Database-Engineer Exam Questions

Become Google Certified with updated Professional-Cloud-Database-Engineer exam questions and correct answers

Page: 1 / 29

Total 143 Questions | Updated On: Mar 20, 2026

Add To Cart

Question 1

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

A : t up all read replicas in a different region using asynchronous replication.

B : t up all read replicas in the same region as the primary instance with synchronous replication.

C : t up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

D : t up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

Answer: C

Question 2

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

A : Issue a gcloud sql instances patch command to increase the number of vCPUs.

B : Update a MySQL database flag to increase the number of vCPUs.

C : Issue a gcloud compute instances update command to increase the number of vCPUs.

D : Back up the database, create an instance with additional vCPUs, and restore the database.

Answer: A

Question 3

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Googlerecommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

A : Reuse the existing service account that populates this database.

B : Create a new service account, and grant it the Cloud Spanner Database Admin role.

C : Create a new service account, and grant it the Cloud Spanner Database Reader role.

D : Create a new service account, and grant it the spanner.databases.select permission.

Answer: C

Question 4

You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

A : Setup a static external IP address in your VPC network.

B : Set up bring your own IP (BYOIP) in your VPC.

C : Set up a Cloud NAT gateway on the Compute Engine VM.

D : Set up Cloud NAT service.

Answer: C

Question 5

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

A : Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

B : Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C : Create a read replica in another region, and promote the read replica if a failure occurs.

D : Enable high availability (HA) for the database to make it regional.

Answer: D

Page: 1 / 29

Total 143 Questions | Updated On: Mar 20, 2026

Add To Cart