Free Google Professional-Cloud-Database-Engineer Exam Questions

Question 1

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 2

A :

B :

C :

D :

Answer: C

Question 3

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 : rform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

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

C : Database Migration Service to migrate your database.

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

Answer: B

Question 4

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 5

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 : Cloud Spanner instead of Cloud SQL.

B : crease the number of CPUs for your instance.

C : crease the storage size for the instance

D : many smaller Cloud SQL instances.

Answer: A