Free Google Professional-Cloud-Database-Engineer Exam Questions

Question 1

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

A : Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

B : Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C : Create a read replica in another region, and promote the read replica if a failure occurs.

D : Enable high availability (HA) for the database to make it regional.

Answer: D

Question 2

You are migrating an on-premises application to Google Cloud. The application requires a high availability

(HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy

requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure.

You plan to use a Google Cloud managed service. What should you do to maximize uptime for your

application?

A : Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zonein the same region and a read replica in another region for disaster recovery.

B : Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodicbackups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another regionduring a disaster recovery event.

C : Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-regionread replica, and promote the read replica as the primary node for disaster recovery.

D : Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will notaffect your application. Update the schema to support Cloud Spanner data types, and refactor theapplication.

Answer: C

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 want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

A : Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

B : Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C : Create a read replica in another region, and promote the read replica if a failure occurs.

D : Enable high availability (HA) for the database to make it regional.

Answer: D

Question 5

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