Free Google Professional-Cloud-Database-Engineer Exam Questions

Question 1

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

Question 2

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

A : Set up manual backups.

B : Create a PostgreSQL database on-premises as the HA option.

C : Configure single zone availability for automated backups.

D : Enable point-in-time recovery.

E : Schedule automated backups.

Answer: D,E

Question 3

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

A : Set up manual backups.

B : Create a PostgreSQL database on-premises as the HA option.

C : Configure single zone availability for automated backups.

D : Enable point-in-time recovery.

E : Schedule automated backups.

Answer: D,E

Question 4

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Googlerecommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

A : Reuse the existing service account that populates this database.

B : Create a new service account, and grant it the Cloud Spanner Database Admin role.

C : Create a new service account, and grant it the Cloud Spanner Database Reader role.

D : Create a new service account, and grant it the spanner.databases.select permission.

Answer: C

Question 5

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

A : Export the data from the existing database, and load the data into a new Cloud SQL database.

B : Use Migrate for Compute Engine to complete the migration.

C : Use Datastream to complete the migration.

D : Use Database Migration Service to complete the migration.

Answer: D