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

Question 121

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

A.Use highly available Cloud SQL with multiple zones.

B.Use Cloud SQL with cross-region replicas.

C.Use Cloud Spanner in a regional configuration.

D.Use Cloud Spanner in a multi-region configuration.

Question 122

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

A.Use staleness of at least 15 seconds.

B.Add more read-write replicas.

C.Place the bulk of the read and write workloads closer to the default leader region.

D.Keep the total CPU utilization under 45% in each region.

Question 123

A.Use Cloud Spanner in a regional configuration.

B.Use Cloud Spanner in a multi-region configuration.

C.Use Cloud SQL with cross-region replicas.

D.Use highly available Cloud SQL with multiple zones.

Question 124

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

A.Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

B.Use Database Migration Service to migrate your database.

C.Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

D.Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

Question 125

You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse.
What should you do?

A.Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

B.Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

C.Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

D.Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.

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

Latest Upload: 132Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 143SAP.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; 206CIRO.RSE.v2026-08-12.q41; 175CrowdStrike.CCSE-204.v2026-08-12.q50; 163ISQI.CT-GenAI.v2026-08-11.q14

Question 121

Question 122

Question 123

Question 124

Question 125

Download PDF File