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

Question 81

You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?

A.Migrate to Compute Engine.

B.Migrate to Bare Metal Solution for Oracle.

C.Migrate to Google Kubernetes Engine (GKE)

D.Migrate to Google Cloud VMware Engine

Question 82

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?

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

B.Use a Bigtable instance with clusters in multiple regions.

C.Use Cloud SQL for PostgreSQL with both cross-region read replicas.

D.Use Firestore in Datastore mode.

Question 83

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 84

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

A.Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

B.Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

C.Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

D.Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

Question 85

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

A.Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

B.Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

C.Set up all read replicas in a different region using asynchronous replication.

D.Set up all read replicas in the same region as the primary instance with synchronous replication.

Other Version: 336Google.Professional-Cloud-Database-Engineer.v2026-06-22.q177

Latest Upload: 174NAHQ.CPHQ.v2026-09-03.q481; 113SAP.C-S4CPB-2602.v2026-09-02.q7; 109Cisco.700-805.v2026-09-02.q86; 161MSSC.CLT-4.0.v2026-09-02.q43; 126Fitness.NCSF-CPT.v2026-09-02.q18; 174Google.Generative-AI-Leader.v2026-09-02.q77; 139PECB.ISO-14001-Lead-Auditor.v2026-09-01.q39; 126Google.GCP-DE.v2026-09-01.q27; 160Cisco.300-820.v2026-09-01.q105; 154Cisco.500-220.v2026-09-01.q72

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File