Free Access Google.Professional-Cloud-Database-Engineer.v2024-04-26.q86 Practice Test (Page 17)

Question 76

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

A.Migrate the Oracle databases to Cloud Spanner.

B.Migrate the Oracle databases to Compute Engine.

C.Migrate the Oracle databases to Cloud SQL.

D.Migrate the Oracle databases to Bare Metal Solution for Oracle.

Question 77

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 78

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

A.Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

B.Use Cloud Composer to execute a select * from table(s) query and export results.

C.Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

D.Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

Question 79

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

A.Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

B.Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

C.Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

D.Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

Question 80

Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?

A.Use Google Workspace Password Sync to replicate passwords into Google Cloud.

B.Ask existing users to set their Google password to match their corporate password.

C.Use workload identity federation to impersonate a service account.

D.Migrate the application to Google Cloud, and use Identity and Access Management (IAM).

Latest Upload: 201PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 296Nokia.4A0-113.v2026-05-01.q69; 253EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 209Salesforce.MC-202.v2026-04-30.q57; 205BICSI.INSTC_V8.v2026-04-29.q53; 333NMLS.MLO.v2026-04-28.q82; 242NCARB.Project-Management.v2026-04-28.q27; 459EMC.D-AV-DY-23.v2026-04-27.q184; 1113ServiceNow.CSA.v2026-04-27.q483

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File