Professional-Cloud-Database-Engineer Exam Dumps - Google Cloud Certified - Professional Cloud Database Engineer

Go to page:

Question # 4

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Shut down your existing Cloud SQL for MySQL instance, and enable HA.

Full Access

Question # 5

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?

Setup a static external IP address in your VPC network.

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

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

Set up Cloud NAT service.

Full Access

Question # 6

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?

Use Logs Explorer to analyze log data.

Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

Use Error Reporting to count, analyze, and aggregate the data.

Use Cloud Debugger to inspect the state of an application.

Full Access

Question # 7

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

Create your database with one primary node and one read replica in the region.

Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

Configure your Cloud SQL instance with high availability enabled.

Full Access

Question # 8

Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. Youwant to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

Apply a schema data management pattern.

Apply an instance data management pattern.

Apply a table data management pattern.

Apply a database data management pattern.

Full Access