Question 1

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

Options :

A :

Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

B : Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

C : Use Database Migration Service to migrate your database.

D : Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Answer: D

Question 2

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 3

You are choosing a new database backend for an existing application. The current database is running

PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The

application data is relational and has light traffic. You want to minimize costs and the migration effort for this

application. What should you do?

Options :

A : Migrate the existing database to Firestore.

B : Migrate the existing database to Cloud SQL for PostgreSQL.

C : Migrate the existing database to Cloud Spanner.

D : Migrate the existing database to PostgreSQL running on Compute Engine.

Answer: B

Question 4

You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

Options :

A :

Maintain a target of 23% CPU utilization by locating:

cluster-a in zone us-central1-a

cluster-b in zone europe-west1-d

cluster-c in zone asia-east1-b

B :

Maintain a target of 23% CPU utilization by locating:

cluster-a in zone us-central1-a

cluster-b in zone us-central1-b

cluster-c in zone us-east1-a

C :

Maintain a target of 35% CPU utilization by locating:

cluster-a in zone us-central1-a

cluster-b in zone australia-southeast1-a

cluster-c in zone europe-west1-d

cluster-d in zone asia-east1-b

D :

Maintain a target of 35% CPU utilization by locating:

cluster-a in zone us-central1-a

cluster-b in zone us-central2-a

cluster-c in zone asia-northeast1-b

cluster-d in zone asia-east1-b

Answer: D

Question 5

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in

production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the

application that is originating the inefficient queries. You want to follow Google-recommended practices.

What should you do?

Options :

A :

Shut down and restart each application.

B :

Write a utility to scan database query logs.

C :

Write a utility to scan application logs.

D : Use query tags to add application-centric database monitoring.

Answer: D

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

Buying Options: