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

Question 166

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

A.Use Database Migration Service to migrate all databases to Cloud SQL.

B.Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.

C.Use data replication tools and CDC tools to enable migration.

D.Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Question 167

BrightTrail Outfitters is moving an order processing platform from its data center to Google Cloud.
The application depends on a MySQL backend that must remain highly available because it supports mission critical transactions. The business requires a recovery time objective and a recovery point objective of no more than 12 minutes during a regional incident. You will use a Google managed database service. What should you implement to achieve the highest possible uptime for this workload?

A.Migrate the database to multi region Cloud Spanner and refactor the schema and application so that a regional outage does not interrupt service

B.Set up Cloud SQL for MySQL with regional high availability and rely on scheduled backups to restore a new instance in a different region when a disaster occurs

C.Provision Cloud SQL for MySQL with regional high availability and create a cross region read replica that you can promote to primary if the region fails

D.Deploy Cloud SQL for MySQL as a single zone instance and add a read replica in another zone and a second replica in a distant region for disaster recovery

Question 168

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

B.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.

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.

Question 169

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

A.Create one regional Cloud SQL instance with a read replica in another region.

B.Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

C.Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

D.Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Question 170

You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?

A.Use Cloud Spanner with a customer-managed encryption key (CMEK).

B.Use Cloud SQL with a customer-managed encryption key (CMEK).

C.Use Cloud Spanner with default encryption.

D.Use Bigtable with default encryption.

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 166

Question 167

Question 168

Question 169

Question 170

Download PDF File