[Jun-2026] Professional-Cloud-Database-Engineer Dumps Full Questions - Google Cloud Certified Exam Study Guide
Exam Questions and Answers for Professional-Cloud-Database-Engineer Study Guide
The Google Professional-Cloud-Database-Engineer exam is intended for cloud professionals who have practical experience in database design, management, and maintenance. Google Cloud Certified - Professional Cloud Database Engineer certification is designed for individuals who design, develop, and manage cloud-based database solutions, and provide the technical expertise required to maintain high availability, data security, and scalability.
Google Professional-Cloud-Database-Engineer certification is a certification exam offered by Google Cloud that focuses on database management and engineering. Google Cloud Certified - Professional Cloud Database Engineer certification is designed for individuals who are responsible for managing and designing enterprise database systems on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam measures the candidate's ability to design, build, and manage scalable and reliable databases on the Google Cloud Platform.
NEW QUESTION # 33
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
- A. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
- B. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
- C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
- D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Answer: A
NEW QUESTION # 34
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?
- A. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- B. Use Cloud Spanner with a custom autoscaling solution.
- C. Use a Biglable cluster with autoscaling.
- D. Use sharded Cloud SQL instances with one or more stores per database instance.
Answer: D
NEW QUESTION # 35
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?
- A. Verify that the new replica is created automatically.
- B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- C. Start the original primary instance and resume replication.
- D. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
Answer: A
Explanation:
Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization: Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.
NEW QUESTION # 36
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
- A. Use Cloud Spanner for data storage.
- B. Use Memorystore for data storage.
- C. Use Cloud SQL for data storage.
- D. Use Bigtable for data storage.
Answer: C
NEW QUESTION # 37
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
- A. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
- B. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
- C. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
- D. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
Answer: B
NEW QUESTION # 38
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest dat a. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?
- A. Create a read replica for the Sales Reporting application.
- B. Queue up all the requested reports in PubSub, and execute the reports at night.
- C. Use a Cloud SQL federated query for the Sales Reporting application.
- D. Create two separate databases in the instance, and perform dual writes from the Order Management application.
Answer: A
NEW QUESTION # 39
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 instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
- B. Configure the primary, standby, and read replica instances in zone A, 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: A
Explanation:
https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview
NEW QUESTION # 40
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?
- A. Modify the database schema, and add additional indexes.
- B. Decrease the number of processing units.
- C. Increase the number of processing units.
- D. Shard data required by the application into multiple instances.
Answer: C
Explanation:
In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs
/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%
20the%20CPU%20utilization%20of%20the%20instance%20is%20above%20the%20recommended%
20level%2C%20you%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%
20auto%20scaling. "Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling." Indexes and schema are reviewed post identifying query with slow performance.Refer :https://cloud.google.com/spanner/docs
/troubleshooting-performance-regressions#review-schema
NEW QUESTION # 41
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. Create a streaming Datatlow job to export the table.
- C. Run the cron job on a Compute Engine instance to continue the export.
- D. Set up Cloud Composer, and create a task to export the table daily.
Answer: D
NEW QUESTION # 42
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?
- A. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- B. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
- C. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
- D. 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.
Answer: C
Explanation:
Cloud Monitoring collects metrics, events, and metadata from Google Cloud, Amazon Web Services (AWS), hosted uptime probes, and application instrumentation. Using the BindPlane service, you can also collect this data from over 150 common application components, on-premise systems, and hybrid cloud systems.
NEW QUESTION # 43
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
- A. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
- B. If the corruption is significant, use import and export.
- C. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- D. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- E. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
Answer: C,D
Explanation:
https://cloud.google.com/spanner/docs/pitr#ways-to-recover
To recover the entire database, backup or export the database specifying a timestamp in the past and then restore or import it to a new database. This is typically used to recover from data corruption issues when you have to revert the entire database to a point-in-time before the corruption occurred.
This part describes significant corruption - A
To recover a portion of the database, perform a stale read specifying a query-condition and timestamp in the past, and then write the results back into the live database. This is typically used for surgical operations on a live database. For example, if you accidentally delete a particular row or incorrectly update a subset of data, you can recover it with this method.
This describes insignificant corruption case - E
https://cloud.google.com/spanner/docs/pitr https://cloud.google.com/spanner/docs/backup/restore-backup
NEW QUESTION # 44
You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?
- A. Use Cloud Spanner in a multi-region configuration.
- B. Use Firestore in Datastore mode.
- C. Use a Bigtable instance with clusters in multiple regions.
- D. Use Cloud SQL for PostgreSQL with both cross-region read replicas.
Answer: A
Explanation:
https://cloud.google.com/blog/products/databases/manage-semi-structured-data-in-cloud-spanner-with-json
NEW QUESTION # 45
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?
- A. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
- B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
- C. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
- D. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr
NEW QUESTION # 46
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
- A. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
- B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
- C. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- D. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
Answer: B
NEW QUESTION # 47
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?
- A. Modify the database schema, and add additional indexes.
- B. Decrease the number of processing units.
- C. Increase the number of processing units.
- D. Shard data required by the application into multiple instances.
Answer: C
NEW QUESTION # 48
......
Google Cloud Certified - Professional Cloud Database Engineer Free Update With 100% Exam Passing Guarantee: https://www.vceengine.com/Professional-Cloud-Database-Engineer-vce-test-engine.html
Real Exam Questions and Answers - Google Professional-Cloud-Database-Engineer Dump is Ready: https://drive.google.com/open?id=1yn9E5UJ2hEBWGJo4DBC7OGNjzpkziSa6
