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

Question 136

You have several on-premises Percona Server for MySQL 8.0 instances used for mission-critical applications. The workload is read-heavy with 80%+ reads and each instance has several TBs of data. You want to migrate to Google Cloud with minimal downtime and the fewest changes possible.
What should you do-

A.Use Database Migration Service to migrate to Alloy DB.

B.Use Datastream to migrate to Cloud SQL Enterprise

C.Use the spanner-migration-tool to migrate to Spanner.

D.Use Database Migration Service to migrate to Cloud SQL Enterprise Plus.

Question 137

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?

A.Migrate the existing database to Firestore.

B.Migrate the existing database to Cloud SQL for PostgreSQL.

C.Migrate the existing database to Cloud Spanner.

D.Migrate the existing database to PostgreSQL running on Compute Engine.

Question 138

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

A.Use query parameters to speed up frequently executed queries.

B.Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

C.Change the Cloud Spanner configuration from multi-region to single region.

D.Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

Question 139

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 140

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

A.Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.

B.Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance.

C.Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

D.Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

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

Latest Upload: 206Cisco.300-610.v2026-08-19.q170; 194CompTIA.PT0-003.v2026-08-19.q179; 153Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 148SAP.C_CR125_2601.v2026-08-17.q28; 210Salesforce.Field-Service-Consultant.v2026-08-17.q134; 167Oracle.1Z0-1170.v2026-08-16.q64; 175Oracle.1Z1-1170.v2026-08-16.q64; 200Juniper.JN0-336.v2026-08-13.q60; 373EMC.NCP-AII.v2026-08-13.q200; 221CIRO.RSE.v2026-08-12.q41

Question 136

Question 137

Question 138

Question 139

Question 140

Download PDF File