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

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 2

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 3

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This

application must be able to:

Work with transactions and offer strong consistency.

Work with structured and semi-structured (JSON) data.

Scale transparently to multiple regions globally as the operation grows.

You need a Google Cloud database that meets all the requirements of the application. What should you do?

A : Cloud SQL for PostgreSQL with both cross-region read replicas.

B : Cloud Spanner in a multi-region configuration.

C : Firestore in Datastore mode.

D : a Bigtable instance with clusters in multiple regions.

Answer: A

Question 4

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 5

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

Page: 1 / 29

Total 143 Questions | Updated On: Feb 21, 2026

Add To Cart