Professional-Cloud-Database-Engineer Google Cloud Certified - Professional Cloud Database Engineer exact Exam Questions

Google Cloud Certified - Professional Cloud Database Engineer

Last Update 12 hours ago Total Questions : 141

The Google Cloud Certified - Professional Cloud Database Engineer content is now fully updated, with all current exam questions added 12 hours ago. Deciding to include Professional-Cloud-Database-Engineer practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our Professional-Cloud-Database-Engineer exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these Professional-Cloud-Database-Engineer sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Google Cloud Certified - Professional Cloud Database Engineer practice test comfortably within the allotted time.

Question # 1

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

Increase the number of processing units.

Modify the database schema, and add additional indexes.

Shard data required by the application into multiple instances.

Decrease the number of processing units.

Question # 2

You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.

Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.

Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

Question # 3

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

Use Cloud Scheduler and Cloud Functions to run the daily export.

Create a streaming Datatlow job to export the table.

Set up Cloud Composer, and create a task to export the table daily.

Run the cron job on a Compute Engine instance to continue the export.

Question # 4

You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

Use the Google Cloud Console or gcloud CLI to manually create a new clone database.

Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.

Verify that the new replica is created automatically.

Start the original primary instance and resume replication.

Question # 5

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

Close idle connections or restart the instance before beginning the import operation.

Increase the amount of memory allocated to your instance.

Ensure that the service account has the Storage Admin role.

Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

Question # 6

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?

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

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

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

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

Question # 7

An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?

roles/cloudsql.viewer and roles/spanner.databaseUser

roles/cloudsql.editor and roles/spanner.admin

roles/cloudsql.client and roles/spanner.databaseReader

roles/cloudsql.instanceUser and roles/spanner.databaseUser

Question # 8

Your team is building an application that stores and analyzes streaming time series financial data. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?

Use Firestore.

Use Bigtable

Use BigQuery.

Use Cloud Spanner.

Question # 9

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

Question # 10

You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non-mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do?

Increase the size of the read replica Instance and enable MA.

Enable HA on the current read replica.

Create a new HA instance in the same zone db lie primary.

Create a new MA Instance in a different region than the primary.