Free Google Professional-Cloud-Database-Engineer Exam Questions

Question 1

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 : ing DB-1 back online.

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

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

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

Answer: C

Question 2

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Googlerecommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

A : Manually scale down the number of nodes after the peak period has passed.

B : Use interleaving to co-locate parent and child rows.

C : Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

D : Use granular instance sizing in Cloud Spanner and Autoscaler.

Answer: D

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

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 5

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Googlerecommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

A : Manually scale down the number of nodes after the peak period has passed.

B : Use interleaving to co-locate parent and child rows.

C : Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

D : Use granular instance sizing in Cloud Spanner and Autoscaler.

Answer: D