Free Google Professional-Cloud-Database-Engineer Exam Practice Questions 2026

Stay ahead with 100% Free Professional Cloud Database Engineer Professional-Cloud-Database-Engineer Practice Test Questions Dumps

Page: 1 / 29

Total 143 Questions | Updated On: Jul 14, 2026

Add To Cart

Question 1

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 2

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

A : Set up manual backups.

B : Create a PostgreSQL database on-premises as the HA option.

C : Configure single zone availability for automated backups.

D : Enable point-in-time recovery.

E : Schedule automated backups.

Answer: D,E

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

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

A : Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

B : Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

C : Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

D : Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team

Answer: B

Question 5

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

A : Migrate the databases to Cloud Spanner.

B : Migrate the databases to Cloud SQL, and enable a standby database.

C : Migrate the databases to Compute Engine using regional persistent disks.

D : Migrate the databases to Bare Metal Solution for Oracle.

Answer: B

Page: 1 / 29

Total 143 Questions | Updated On: Jul 14, 2026

Add To Cart