Updated Google Professional Cloud Database Engineer Exam Dumps

Question No: 1

MultipleChoice

Your company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?

Options

Aroles/spanner.databaseReader

Broles/spanner.databaseUser

Croles/spanner.viewer

Droles/spanner.backupWriter

Question No: 2

MultipleChoice

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

Options

AExport the data from the existing database, and load the data into a new Cloud SQL database.

BUse Migrate for Compute Engine to complete the migration.

CUse Datastream to complete the migration.

DUse Database Migration Service to complete the migration.

Question No: 3

MultipleChoice

You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?

Options

A1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Use Cloud SQL Auth proxy to connect to the instance.

B1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Connect to the instance using a connection pool to best manage connections to the instance.

C1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Use Cloud SQL Auth proxy to connect to the instance.

D1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Connect to the instance using a connection pool to best manage connections to the instance.

Question No: 4

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: 5

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: 6

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: 7

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: 8

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 September 2026