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

Question 11

You are planning to migrate a 10TB relational database from an on-premises environment la 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 2 answers

A.Establish a Private Se-vice Connect connection between your on-premises environment and the Cloud SQL instance

B.Use an external IH address for the Cloud SQL Instance, and configure firewall rules.

C.Leverage Storage Transfer Service with client side encryption.

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

E.Set up identity Access Management JIAM) roles to restrict access with Cloud SQL with an internal IP address.

Question 12

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?

A.Use Logs Explorer to analyze log data.

B.Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

C.Use Error Reporting to count, analyze, and aggregate the data.

D.Use Cloud Debugger to inspect the state of an application.

Question 13

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

A.View Cloud SQL operations to view historical query information.

B.White a Logs Explorer query to identify database queries with high execution times.

C.Review application logs to identify database calls.

D.Use the Query Insights dashboard to identify high execution times.

Question 14

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

A.Drop or disable all users except database administration users.

B.Disable all foreign key constraints on the source PostgreSQL database.

C.Ensure that all PostgreSQL tables have a primary key.

D.Shut down the database before the Data Migration Service task is started.

E.Ensure that pglogical is installed on the source PostgreSQL database.

Question 15

Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

A.Use Bigtable.

B.Use Cloud Spanner.

C.Use Firestore.

D.Use Cloud SQL.

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 11

Question 12

Question 13

Question 14

Question 15

Download PDF File