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

Go to page:

Question # 4

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

Use Cloud Composer to execute a select * from table(s) query and export results.

Full Access

Question # 5

Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.

Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.

Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

Full Access

Question # 6

You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

Disable and remove the internal IP address assignment.

Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.

Specify an authorized network with the CIDR range of the VM.

Disable and remove the external IP address assignment.

Full Access

Question # 7

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 # 8

Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.

Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.

Full Access

Go to page: