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

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

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 : Cloud SQL for PostgreSQL with both cross-region read replicas.

B : Cloud Spanner in a multi-region configuration.

C : Firestore in Datastore mode.

D : a Bigtable instance with clusters in multiple regions.

Answer: A

Question 4

A :

B :

C :

D :

Answer: C

Question 5

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

A : Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in useast1 and us-west1.

B : Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and uswest1.

C : Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in uscentral1, us-east1, and us-west1.

D : Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, useast1 and us-west1.

Answer: A