[Oct 17, 2025] Get Up-To-Date Real Exam Questions for Professional-Cloud-Database-Engineer with New Materials
Updated Professional-Cloud-Database-Engineer Certification Exam Sample Questions
The Google Professional-Cloud-Database-Engineer exam consists of multiple choice and multiple select questions, with a total of 50 questions that must be completed within a time limit of two hours. To pass the exam, candidates must achieve a score of 70% or higher. Professional-Cloud-Database-Engineer exam can be taken online or in-person at a Google Cloud testing center.
NEW QUESTION # 70
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For each application code, set up a dedicated user account.
- B. For each application code, set up a common shared user account.
- C. For the application server, set up a common shared user account.
- D. For the application server, set up a service account.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account
NEW QUESTION # 71
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)
- A. Identify whether the source database uses customer-managed encryption keys (CMEK).
- B. Identity all tables that do not have at least one foreign key.
- C. Identify whether the database has over 512 tables.
- D. Identify whether the source database is encrypted using pgcrypto extension.
- E. Identify all tables that do not have a primary key.
Answer: A,B
NEW QUESTION # 72
Your organization is running a critical production database on a virtual machine (VM) on Compute Engine.
The VM has an ext4-formatted persistent disk for data files. Thedatabase will soon run out of storage space.
You need to implement a solution that avoids downtime. What should you do?
- A. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
- B. In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
- C. In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
- D. In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
Answer: A
Explanation:
https://cloud.google.com/compute/docs/disks/resize-persistent-disk#resize_partitions
NEW QUESTION # 73
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For each application code, set up a dedicated user account.
- B. For the application server, set up a service account.
- C. For each application code, set up a common shared user account.
- D. For the application server, set up a common shared user account.
Answer: A
NEW QUESTION # 74
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
- A. Use customer-managed encryption keys with Cloud SQL.
- B. Use Cloud SQL Auth proxy.
- C. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- D. Connect to Cloud SQL using a connection that has SSL encryption.
Answer: A
NEW QUESTION # 75
Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?
- A. Watch Query Insights for long running queries.
- B. Watch the Cloud SQL recommenders for overprovisioned instances.
- C. Watch the Cloud SQL instance monitor for CPU utilization metrics.
- D. Watch Cloud Trace for application requests that are failing.
Answer: A
Explanation:
Cloud Trace doesn't support Cloud SQL. Eliminate D. Cloud SQL recommenders for overprovisioned instances would tell you about Cloud SQL instances which are too large for their workload. Eliminate C. Monitoring CPU utilization wouldn't tell you why microservice calls are failing. Eliminate B. SQLcommenter integrates with Query Insights. So A is the best answer. https://cloud.google.com/blog/topics/developers-practitioners/introducing-sqlcommenter-open-source-orm-auto-instrumentation-library
NEW QUESTION # 76
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?
- A. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- B. Increase the amount of memory allocated to your instance.
- C. Close idle connections or restart the instance before beginning the import operation.
- D. Ensure that the service account has the Storage Admin role.
Answer: D
NEW QUESTION # 77
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?
- A. Use Key Visualizer for Bigtable.
- B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
- C. Isolate the data analysts and operations user groups to use different Bigtable instances.
- D. Add more nodes to the Bigtable cluster.
Answer: A
Explanation:
https://cloud.google.com/bigtable/docs/performance#troubleshooting
NEW QUESTION # 78
You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?
- A. Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.
- B. Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.
- C. Connect by using the private IP address of the AlloyDB cluster directly from the application.
- D. Connect by using AlloyDB Auth Proxy installed in the GKE cluster.
Answer: C
NEW QUESTION # 79
You are migrating critical production database from Amazon RDS for MySQL to Cloud SQL for MYSQL by using Google Cloud's Migration Service.
You want to keep disruption to your production database to minimum and, at the same time, optimize migration performance. What should you do?
- A. Create a single Database Migration Service migration job with initial Load Parallelism configured to Maximum on the Amazon RDS for MySQL primary instance.
- B. Create a single Database Migration Service migration job with initial load parallelism configured to maximum on the source Amazon RDS for MySQL read replica.
- C. Upgrade the Amazon RDS for MySQL primary instance to an instance with more vCPUs and memory, and then run Google Cloud's Database Migration Service.
- D. Create and start multiple Database Migration Service jobs to migrate your database to the target Cloud SQL for MySQL instance.
Answer: B
NEW QUESTION # 80
You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?
- A. Create a new VPC network in each project, and use VPC Network Peering to connect the two together.
- B. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.
- C. Place both the application VMs and the Cloud SQL instances in the default network of each project.
- D. Use the default networks, and leverage Cloud VPN to connect the two together.
Answer: B
Explanation:
https://groups.google.com/g/google-cloud-sql-discuss/c/M5G5_HPXytY?pli=1
NEW QUESTION # 81
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?
- A. Enable the Cloud SQL Admin API.
- B. Check whether your service account has cloudsql.instances.connect permission.
- C. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- D. Ensure that you are using an external (public) IP address interface.
Answer: C
NEW QUESTION # 82
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?
- A. Use Cloud Scheduler and Cloud Functions to run the daily export.
- B. Set up Cloud Composer, and create a task to export the table daily.
- C. Create a streaming Datatlow job to export the table.
- D. Run the cron job on a Compute Engine instance to continue the export.
Answer: A
Explanation:
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler
NEW QUESTION # 83
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?
- A. Configure the primary, standby, and read replica instances in zone A, all in the same region.
- B. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
- C. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
- D. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
Answer: C
NEW QUESTION # 84
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?
- A. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance. - B. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - C. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - D. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
Answer: D
Explanation:
https://cloud.google.com/database-migration/docs/mysql/configure-source-database To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.
NEW QUESTION # 85
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?
- A. Use Firestore and ensure that the PersistenceEnabled option is set to true.
- B. Use Memorystore for Memcached.
- C. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
- D. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
Answer: D
NEW QUESTION # 86
......
Professional-Cloud-Database-Engineer Study Guide Cover to Cover as Literally: https://pass4sure.trainingquiz.com/Professional-Cloud-Database-Engineer-training-materials.html
