Question 1

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

Options :

A : Use an external read replica to migrate the databases to Cloud SQL.

B : Use a read replica to migrate the databases to Cloud SQL.

C : Use Database Migration Service to migrate the databases to Cloud SQL.

D : Use a cross-region read replica to migrate the databases to Cloud SQL.

E : Use replication from an external server to migrate the databases to Cloud SQL.

Answer: C,E

Question 2

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

Options :

A : Set up manual backups.

B : Create a PostgreSQL database on-premises as the HA option.

C : Configure single zone availability for automated backups.

D : Enable point-in-time recovery.

E : Schedule automated backups.

Answer: D,E

Question 3

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

Options :

A : Migrate the databases to Cloud Spanner.

B : Migrate the databases to Cloud SQL, and enable a standby database.

C : Migrate the databases to Compute Engine using regional persistent disks.

D : Migrate the databases to Bare Metal Solution for Oracle.

Answer: B

Question 4

You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

Options :

A : Setup a static external IP address in your VPC network.

B : Set up bring your own IP (BYOIP) in your VPC.

C : Set up a Cloud NAT gateway on the Compute Engine VM.

D : Set up Cloud NAT service.

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?

Options :

A : Use Firestore.

B : Use Cloud Spanner.

C : Use Cloud SQL.

D : Use Bigtable.

Answer: B

Free Professional-Cloud-Database-Engineer Mock Exam – Practice Online Confidently

Buying Options: