Free Google Professional-Cloud-Database-Engineer Exam Questions

Question 1

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 2

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

A : Use Bigtable.

B : Use Firestore.

C : Use Cloud SQL for MySQL

D : Use Cloud Spanner.

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 organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

A : Use replication to roll out changes to higher environments.

B : Use backup and restore to roll out changes to higher environments.

C : Use Liquibase to roll out changes to higher environments.

D : Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

Answer: C

Question 5