Latest [May 07, 2026] Professional-Cloud-Database-Engineer Exam with Accurate Google Cloud Certified - Professional Cloud Database Engineer PDF Questions
Take a Leap Forward in Your Career by Earning Google 144 Questions
Google Professional-Cloud-Database-Engineer certification exam covers a wide range of topics related to cloud-based database solutions. Professional-Cloud-Database-Engineer exam is designed to test the candidate's knowledge of GCP's database services and their ability to design, configure, and manage databases using various GCP tools and services. Professional-Cloud-Database-Engineer exam also focuses on the candidate's knowledge of database design patterns, data modeling techniques, and best practices for database security, scalability, and performance.
The Professional-Cloud-Database-Engineer exam is intended for database engineers who are responsible for designing, developing, and managing databases on GCP. Professional-Cloud-Database-Engineer exam covers a broad range of topics, including database design, data modeling, database management, database security, and data analysis.
NEW QUESTION # 61
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. Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.
- B. Connect by using AlloyDB Auth Proxy installed in the GKE cluster.
- C. Connect by using the private IP address of the AlloyDB cluster directly from the application.
- D. 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.
Answer: C
NEW QUESTION # 62
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. Use the default networks, and leverage Cloud VPN to connect the two together.
- C. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.
- D. Place both the application VMs and the Cloud SQL instances in the default network of each project.
Answer: C
Explanation:
https://groups.google.com/g/google-cloud-sql-discuss/c/M5G5_HPXytY?pli=1
NEW QUESTION # 63
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 Cloud SQL Auth proxy.
- B. Connect to Cloud SQL using a connection that has SSL encryption.
- C. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- D. Use customer-managed encryption keys with Cloud SQL.
Answer: D
NEW QUESTION # 64
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?
- A. Use MongoD8 Atlas with Charts.
- B. Use Firestore with Looker.
- C. Use Cloud Spanner with Data Studio.
- D. Use Bigtable with Looker.
Answer: A
NEW QUESTION # 65
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 SQL for data storage.
- B. Use Bigtable for data storage.
- C. Use Memorystore for data storage.
- D. Use Cloud Spanner for data storage.
Answer: D
Explanation:
google Cloud Spanner is a highly scalable, reliable, and fully managed relational database service that runs on Google's infrastructure. It's designed to handle large amounts of data and provide high availability, even in the face of failures. Spanner can be used to store and manage data for a variety of applications, including e-commerce websites. Spanner is a good choice for this scenario because it can handle high write throughput and provides 99.99% uptime. It's also a good fit for applications that need to be highly available, even in the face of failures.
NEW QUESTION # 66
You are planning to migrate a 10TB relational database from an on-premises environment la Cloud SQL for PostgreSQL. The database contains sensitive customer Information. You want to follow Google-recommended practices to keep data secure during the migration.
What should you do?
Choose 2 answers
- A. Establish a Private Se-vice Connect connection between your on-premises environment and the Cloud SQL instance
- B. Set up identity Access Management JIAM) roles to restrict access with Cloud SQL with an internal IP address.
- C. Leverage Storage Transfer Service with client side encryption.
- D. Configure Cloud SQL for automatic patching, and enable binary logging.
- E. Use an external IH address for the Cloud SQL Instance, and configure firewall rules.
Answer: A,B
NEW QUESTION # 67
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, perform a stale read and specify a recovery timestamp. Write the results back.
- B. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- C. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- D. If the corruption is significant, use import and export.
- E. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
Answer: A,B
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 # 68
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?
- A. Use an in-app embedded database.
- B. Use Firestore.
- C. Use Cloud Spanner.
- D. Use Cloud SQL with an external (public) IP address.
Answer: B
Explanation:
https://firebase.google.com/docs/firestore
NEW QUESTION # 69
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?
- A. roles/cloudsql.client and roles/spanner.databaseReader
- B. roles/cloudsql.viewer and roles/spanner.databaseUser
- C. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- D. roles/cloudsql.editor and roles/spanner.admin
Answer: B
Explanation:
To read data out of Cloud SQL for SQL Server, you need to use a service account with the roles/cloudsql.viewer role on the Cloud SQL instance. This role grants the service account permission to read data from the instance. Whereas roles/cloudsql.instanceUser will only allow to login to cloud SQL instance. No resource will be allowed to view.
NEW QUESTION # 70
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?
- A. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
- B. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
- C. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
- D. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
Answer: C
NEW QUESTION # 71
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
- A. Use Cloud SQL with a regional read replica to deploy the database.
- B. Use Cloud Spanner to deploy the database.
- C. Use Bigtable with clusters in multiple regions to deploy the database
- D. Use BigQuery to deploy the database
Answer: B
Explanation:
Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, automatic, synchronous replication for high availability, and support for two SQL dialects: Google Standard SQL (ANSI 2011 with extensions) and PostgreSQL.
NEW QUESTION # 72
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. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance 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. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
Answer: D
NEW QUESTION # 73
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
- A. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
- B. Set up different organizations for each database type, and apply policy constraints at the organization level.
- C. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
- D. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
Answer: C
NEW QUESTION # 74
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
- A. Use Dataflow to run the export in text format.
- B. Use Cloud Functions to run the export in Avro format.
- C. Use Dataflow to run the export in Avro format.
- D. Use Cloud Functions to run the export in text format.
Answer: C
NEW QUESTION # 75
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
- A. Use high availability (HA) Cloud SQL with multiple zones.
- B. Use Cloud Spanner in a regional configuration.
- C. Use zonal Cloud SQL without high availability (HA).
- D. Use Cloud SQL with cross-region replicas.
Answer: D
NEW QUESTION # 76
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Bigtable with default encryption.
- B. Use Cloud Spanner with a customer-managed encryption key (CMEK).
- C. Use Cloud Spanner with default encryption.
- D. Use Cloud SQL with a customer-managed encryption key (CMEK).
Answer: D
NEW QUESTION # 77
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?
- A. Create a new MA Instance in a different region than the primary.
- B. Create a new HA instance in the same zone db lie primary.
- C. Increase the size of the read replica Instance and enable MA.
- D. Enable HA on the current read replica.
Answer: D
NEW QUESTION # 78
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?
- A. Replicate Cloud SQL databases across different zones.
- B. Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
- C. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
- D. Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
Answer: D
NEW QUESTION # 79
You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?
- A. Use BigQuery, and load data in batches.
- B. Deploy the database using Cloud Spanner.
- C. Deploy the database using Cloud SQL.
- D. C.Deploy the database using Bigtable.
Answer: D
Explanation:
Bigtable is a scalable, fully managed, and high-performance NoSQL database service that can handle semi-structured data and support real-time monitoring and analysis. Cloud SQL is a relational database service that does not support semi-structured dat a. BigQuery is a data warehouse service that is optimized for batch processing and analytics, not real-time monitoring. Cloud Spanner is a relational database service that supports semi-structured data with JSON data type, but it is more expensive and complex than Bigtable for this use case.
NEW QUESTION # 80
......
Authentic Best resources for Professional-Cloud-Database-Engineer Online Practice Exam: https://www.examslabs.com/Google/Google-Cloud-Certified/best-Professional-Cloud-Database-Engineer-exam-dumps.html
Practice To Professional-Cloud-Database-Engineer - ExamsLabs Remarkable Practice On your Google Cloud Certified - Professional Cloud Database Engineer Exam: https://drive.google.com/open?id=1rUFTD2RDSJ3Y3luhM_8sg6SeatJSzSwV