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

Question 96

You have a Cloud SQL for MySQL instance with a table of product information including a column of product descriptions. Your application development team is building a customer facing chatbot and would like to find the product that most closely matches a freeform text description provided by the customer. How should you enable this functionality-

A.Create a stored procedure that uses a regular expression to match the customer's search text to values in the product description column.

B.Create and populate a column of product description embeddings on the product table and perform an approximate nearest neighbor search using the customer's search text.

C.Use the LIKEoperator to match the customer's search text to the product description and return similar rows.

D.Create a SQL script that compares the product description and the customer's search text by using the SOUNDEXfunction.

Question 97

Your team is building an application that stores and analyzes streaming time series financial data.
You need a database solution that can perform time series-based scans with sub-second latency.
The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?

A.Use Firestore.

B.Use Bigtable

C.Use BigQuery.

D.Use Cloud Spanner.

Question 98

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

A.Use Cloud SQL with cross-region replicas.

B.Use high availability (HA) Cloud SQL with multiple zones.

C.Use zonal Cloud SQL without high availability (HA).

D.Use Cloud Spanner in a regional configuration.

Question 99

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA).
You want to follow Google-recommended practices. What should you do? (Choose two.)

A.Set up manual backups.

B.Create a PostgreSQL database on-premises as the HA option.

C.Configure single zone availability for automated backups.

D.Enable point-in-time recovery.

E.Schedule automated backups.

Question 100

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

A.Create a clone database from a read replica database, and restore the clone into a different zone.

B.Create a clone database from a read replica database, and restore the clone in the same region.

C.Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.

D.Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.

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

Latest Upload: 131Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 142SAP.C_CR125_2601.v2026-08-17.q28; 181Salesforce.Field-Service-Consultant.v2026-08-17.q134; 151Oracle.1Z0-1170.v2026-08-16.q64; 158Oracle.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; 163ISQI.CT-GenAI.v2026-08-11.q14

Question 96

Question 97

Question 98

Question 99

Question 100

Download PDF File