Free Google Professional-Cloud-Database-Engineer Exam Questions

Question 1

Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

A : Use Firestore.

B : Use Cloud Spanner.

C : Use Cloud SQL.

D : Use Bigtable.

Answer: B

Question 2

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

A : Use Identity and Access Management (IAM) authentication.

B : Use Managed Active Directory authentication.

C : Use Cloud SQL federated queries.

D : Use PostgreSQL database's built-in authentication.

Answer: A

Question 3

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

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