Free Practice Google Professional-Cloud-Database-Engineer Exam Questions 2025

Stay ahead with 100% Free Professional Cloud Database Engineer Professional-Cloud-Database-Engineer Dumps Practice Questions

Page: 1 / 27

Total 134 Questions | Updated On: Mar 27, 2025

Add To Cart

Question 1

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

A : Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

B : Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

C : Use Database Migration Service to migrate your database.

D : Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Answer: B

Question 2

Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?

A : Select Bare Metal Solution for Oracle.

B : Select Cloud SQL.

C : Select Bigtable.

D : Select Cloud Spanner.

Answer: D

Question 3

Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?

A : Use Cloud Spanner instead of Cloud SQL.

B : Increase the number of CPUs for your instance.

C : Increase the storage size for the instance.

D : Use many smaller Cloud SQL instances.

Answer: A

Question 4

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

A : Bring DB-1 back online.

B : Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

C : Delete DB-2 so that DB-1 automatically reverts to the primary instance.

D : Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Answer: C

Question 5

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 all read replicas in a different region using asynchronous replication.

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

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

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

Answer: C

Page: 1 / 27

Total 134 Questions | Updated On: Mar 27, 2025

Add To Cart