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

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

A : Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

B : Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

C : Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

D : Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team

Answer: B

Question 3

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 4

A :

B :

C :

D :

Answer: C

Question 5

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