100% Free Google Professional-Cloud-Database-Engineer Practice Test Questions

Question 1

Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?

A : Select Bare Metal Solution for Oracle.

B : Select Cloud SQL.

C : Select Bigtable.

D : Select Cloud Spanner.

Answer: D

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 organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

A : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on all flash storage.Keep backups older than one day stored in Actifio OnVault storage.

B : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on standard storage.Keep backups older than one day stored in Actifio OnVault storage.

C : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on standard storage.Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to aColdline Storage bucket.

D : Create the database on a Bare Metal Solution server with the database running on flash storage.Keep a local backup copy on all flash storage.Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to anArchive Storage bucket.

Answer: B

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

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

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