Professional-Cloud-Database-Engineer Practice Online

Question 1

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

Question 2

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 : Bring DB-1 back online.

B : Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

C : Delete DB-2 so that DB-1 automatically reverts to the primary instance.

D : Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

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

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?

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

Question 5

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

A : Use Cloud SQL with cross-region replicas.

B : Use high availability (HA) Cloud SQL with multiple zones.

C : Use zonal Cloud SQL without high availability (HA).

D : Use Cloud Spanner in a regional configuration.

Answer: A

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

Download Demo Professional-Cloud-Database-Engineer Dumps

Create Account

Password Recovery

Professional-Cloud-Database-Engineer Practice Online

Download Demo Professional-Cloud-Database-Engineer Dumps

Member Login

Create Account

Password Recovery

Professional-Cloud-Database-Engineer Practice Online