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?

Options :

A : Use Cloud SQL for PostgreSQL with both cross-region read replicas.

B : Use Cloud Spanner in a multi-region configuration.

C : Use Firestore in Datastore mode.

D : Use a Bigtable instance with clusters in multiple regions.

Answer: B

Question 2

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

Options :

A : Place the bulk of the read and write workloads closer to the default leader region.

B : Use staleness of at least 15 seconds.

C : Add more read-write replicas.

D : Keep the total CPU utilization under 45% in each region.

Answer: A

Question 3

Your organization has a ticketing system that needs an online marketing analytics and reporting application.

You need to select a relational database that can manage hundreds of terabytes of data to support this new

application. Which database should you use?

Options :

A : Cloud SQL

B : BigQuery

C : Cloud Spanner

D : Bigtable

Answer: B

Question 4

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine

whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize

operational costs and overhead. What should you do?

Options :

A : Create a VM in Compute Engine, and run a cron job.

B : Create a Cloud Composer instance, and create a directed acyclic graph (DAG).

C : Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

D : Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

Answer: C

Question 5

You are migrating an on-premises application to Google Cloud. The application requires a high availability

(HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy

requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure.

You plan to use a Google Cloud managed service. What should you do to maximize uptime for your

application?

Options :

A :

Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone

in the same region and a read replica in another region for disaster recovery.

B :

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic

backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region

during a disaster recovery event.

C :

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region

read replica, and promote the read replica as the primary node for disaster recovery.

D :

Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not

affect your application. Update the schema to support Cloud Spanner data types, and refactor the

application.

Answer: C

Higher Test Marks with Free Online Professional-Cloud-Database-Engineer Exam Practice

Buying Options: