Question 1

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 2

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

Options :

A : Issue a gcloud sql instances patch command to increase the number of vCPUs.

B : Update a MySQL database flag to increase the number of vCPUs.

C : Issue a gcloud compute instances update command to increase the number of vCPUs.

D : Back up the database, create an instance with additional vCPUs, and restore the database.

Answer: A

Question 3

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. Theapplication team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

Options :

A : Isolate the data analysts and operations user groups to use different Bigtable instances.

B : Check the Cloud Monitoring table/bytes_used metric from Bigtable.

C : Use Key Visualizer for Bigtable.

D : Add more nodes to the Bigtable cluster.

Answer: C

Question 4

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 5

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

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

Buying Options: