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 24, 2026

Add To Cart

Question 1

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 2

A :

B :

C :

D :

Answer: C

Question 3

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 4

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 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: Mar 24, 2026

Add To Cart