Updated Google Professional Cloud Database Engineer Exam Dumps

Question No: 1

MultipleChoice

Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

Options

AEnable serializable isolation in the Firebase app.

BDeploy a US multi-region Firestore location.

CBuild a Firestore bundle, and deploy bundles to Cloud CDN.

DCreate a Firestore index on the news story date.

Question No: 2

MultipleChoice

You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non-mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do?

Options

AIncrease the size of the read replica Instance and enable MA.

BEnable HA on the current read replica.

CCreate a new HA instance in the same zone db lie primary.

DCreate a new MA Instance in a different region than the primary.

Question No: 3

MultipleChoice

An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?

Options

Aroles/cloudsql.viewer and roles/spanner.databaseUser

Broles/cloudsql.editor and roles/spanner.admin

Croles/cloudsql.client and roles/spanner.databaseReader

Droles/cloudsql.instanceUser and roles/spanner.databaseUser

Question No: 4

MultipleChoice

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

Options

AUse Cloud SQL with cross-region replicas.

BUse high availability (HA) Cloud SQL with multiple zones.

CUse zonal Cloud SQL without high availability (HA).

DUse Cloud Spanner in a regional configuration.

Question No: 5

MultipleChoice

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat

a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

Options

ADetermine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

BDetermine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

CDetermine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

DDetermine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

Free Google Professional Cloud Database Engineer Exam Dumps June 2026