Free Access Google.Professional-Cloud-Database-Engineer.v2026-06-22.q177 Practice Test (Page 6)

Question 21

You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AlloyDB cluster with Private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AlloyDB in a cost-effective way. What should you do-

A.Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.

B.Connect by using the private IP address of the AlloyDB cluster directly from the application.

C.Connect by using AlloyDB Auth Proxy installed in the GKE cluster.

D.Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.

Question 22

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

A.Modify the database schema, and add additional indexes.

B.Increase the number of processing units.

C.Decrease the number of processing units.

D.Shard data required by the application into multiple instances.

Question 23

You are working on a new centralized inventory management system to track items available in
200 stores, which each have 500 GB of data. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays.
What should you do?

A.Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

B.Use sharded Cloud SQL instances with one or more stores per database instance.

C.Use a Biglable cluster with autoscaling.

D.Use Cloud Spanner with a custom autoscaling solution.

Question 24

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?

A.roles/cloudsql.viewer and roles/spanner.databaseUser

B.roles/cloudsql.editor and roles/spanner.admin

C.roles/cloudsql.client and roles/spanner.databaseReader

D.roles/cloudsql.instanceUser and roles/spanner.databaseUser

Question 25

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

A.Set Terraform deletion_protection to true.

B.Rerun terraform apply.

C.Create a read replica.

D.Use point-in-time-recovery (PITR) to recover the database.

Premium Bundle

Newest Professional-Cloud-Database-Engineer Exam PDF Dumps shared by BraindumpsPass.com for Helping Passing Professional-Cloud-Database-Engineer Exam! BraindumpsPass.com now offer the updated Professional-Cloud-Database-Engineer exam dumps, the BraindumpsPass.com Professional-Cloud-Database-Engineer exam questions have been updated and answers have been corrected get the latest BraindumpsPass.com Professional-Cloud-Database-Engineer pdf dumps with Exam Engine here:

Access Professional-Cloud-Database-Engineer Premium Version

(220 Q&As Dumps, 40%OFF Special Discount: Exam-Tests)

Other Version: 1571Google.Professional-Cloud-Database-Engineer.v2024-04-26.q86

Latest Upload: 153WGU.Introduction-to-IT.v2026-10-03.q47; 199SAP.C_THR81_2605.v2026-10-01.q71; 200Apple.SUP-2026.v2026-10-01.q109; 337CompTIA.N10-009.v2026-10-01.q342; 147Apple.App-Development-with-Swift-Certified-User.v2026-09-30.q14; 193Microsoft.AB-210.v2026-09-30.q53; 212Salesforce.OmniStudio-Consultant.v2026-09-30.q102; 193InsuranceLicensing.Life-and-Accident-and-Health-or-Sickness-Producer-Combo.v2026-09-30.q93; 241Salesforce.Data-Architect.v2026-09-29.q136; 234Huawei.H19-321.v2026-09-29.q100