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: Feb 21, 2026

Add To Cart

Question 1

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 2

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

Question 3

Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

A : Use Firestore.

B : Use Cloud Spanner.

C : Use Cloud SQL.

D : Use Bigtable.

Answer: B

Question 4

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

A : Use Identity and Access Management (IAM) authentication.

B : Use Managed Active Directory authentication.

C : Use Cloud SQL federated queries.

D : Use PostgreSQL database's built-in authentication.

Answer: A

Question 5

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

Page: 1 / 29

Total 143 Questions | Updated On: Feb 21, 2026

Add To Cart