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

Question 26

You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403:
Access Not Configured. What should you do?

A.Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.

B.Check whether your service account has cloudsql.instances.connect permission.

C.Enable the Cloud SQL Admin API.

D.Ensure that you are using an external (public) IP address interface.

Question 27

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

A.Configure the primary, standby, and read replica instances in zone A, all in the same region.

B.Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

C.Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

D.Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

Question 28

You run a toy sales ecommerce application on Spanner. The application contains details about the various product listings such as name, category, description, and review(s). Your leadership wants to enable customers to ask free-form questions about the product catalog. You want to implement this functionality in the easiest, quickest, and least expensive way possible.
What should you do?

A.Create a Spanner full-text search index. Find the product information or review against the user's question in a SQL query. Return the response back to the application.

B.Create, train and deploy a custom ML model(s). Fetch toy details from Spanner and invoke ML predictions from the application layer to return the response.

C.Register an existing Generative AI Vertex model in Spanner. Use the ML.PREDICTfunction to supply the model with a user query along with the product information in a SQL query. Return the response back to the application.

D.Generate vector embeddings for product information in Spanner. Find the vector with the smallest distance between the users' query and existing product information or review by using the EUCLIDEAN_DISTANCE()function in Spanner. Return the closest product information or review.

Question 29

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

A.Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

B.Select a different region to store your backups.

C.Reduce the number of automated backups that are retained to two (2).

D.Set the automated backups to occur every other day to lower the frequency of backups.

Question 30

You are planning to migrate a 10 TB relational database from an on-premises environment to Cloud SQL for PostgreSQL. The database contains sensitive customer information. You want to follow Google-recommended practices to keep data secure during the migration. What should you do- (Choose two.)

A.Configure Cloud SQL for automatic patching, and enable binary logging.

B.Establish a Private Service Connect connection between your on-premises environment and the Cloud SQL instance.

C.Use an external IP address for the Cloud SQL instance, and configure firewall rules.

D.Set up Identity and Access Management (IAM) roles to restrict access with Cloud SQL with an internal IP address.

E.Leverage Storage Transfer Service with client-side encryption.

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

Latest Upload: 129Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 135SAP.C_CR125_2601.v2026-08-17.q28; 179Salesforce.Field-Service-Consultant.v2026-08-17.q134; 150Oracle.1Z0-1170.v2026-08-16.q64; 156Oracle.1Z1-1170.v2026-08-16.q64; 193Juniper.JN0-336.v2026-08-13.q60; 327EMC.NCP-AII.v2026-08-13.q200; 205CIRO.RSE.v2026-08-12.q41; 175CrowdStrike.CCSE-204.v2026-08-12.q50; 162ISQI.CT-GenAI.v2026-08-11.q14

Question 26

Question 27

Question 28

Question 29

Question 30

Download PDF File