Practice Professional-Cloud-Database-Engineer Exam Online

Question 1

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?

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 2

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

A : Set up all read replicas in a different region using asynchronous replication.

B : Set up all read replicas in the same region as the primary instance with synchronous replication.

C : Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

D : Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

Answer: C

Question 3

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

A :

Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your

database changes to Cloud SQL.

Select the Backfill historical data check box on your stream configuration to initiate Datastream to

backfill any data that is out of sync between the source and destination.

Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application

to use the new instance.

B :

Create migration job using Database Migration Service.

Set the migration job type to Continuous, and allow the databases to complete the full dump phase and

start sending data in change data capture (CDC) mode.

Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and

wait for the migration job to complete.

Update your application connections to the new instance.

C :

Create migration job using Database Migration Service.

Set the migration job type to One-time, and perform this migration during a maintenance window.

Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded

into the Cloud SQL destination database and the destination database to be promoted to the primary

database.

Update your application connections to the new instance.

D :

Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance

window.

Move the files to Cloud Storage, and import each database into your Cloud SQL instance.

Continue to dump each database until all the databases are migrated.

Update your application connections to the new instance.

Answer: C

Question 4

Your company is developing a global ecommerce website on Google Cloud. Your development team is

working on a shopping cart service that is durable and elastically scalable with live traffic. Business

disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the

application needs to have very low latency writes. You need a data storage solution that has high write

throughput and provides 99.99% uptime. What should you do?

A : Use Cloud SQL for data storage.

B : Use Cloud Spanner for data storage.

C : Use Memorystore for data storage.

D : Use Bigtable for data storage.

Answer: A

Question 5

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

A :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on all flash storage.

Keep backups older than one day stored in Actifio OnVault storage.

B :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on standard storage.

Keep backups older than one day stored in Actifio OnVault storage.

C :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on standard storage.

Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a

Coldline Storage bucket.

D :

Create the database on a Bare Metal Solution server with the database running on flash storage.

Keep a local backup copy on all flash storage.

Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an

Archive Storage bucket.

Answer: B

Name:	Professional Cloud Database Engineer
Exam Code:	Professional-Cloud-Database-Engineer
Certification:	Google Cloud Certified
Vendor:	Google
Total Questions:	122
Last Updated:	Apr 24, 2024

Google Professional-Cloud-Database-Engineer