View Professional-Cloud-Database-Engineer Exam Question Dumps With Latest Demo [Jan 17, 2026]

Free Professional-Cloud-Database-Engineer Test Questions Real Practice Test Questions

Google Professional-Cloud-Database-Engineer certification exam is designed to test the skills and knowledge of professionals who are responsible for designing, building, and maintaining cloud-based database solutions. Google Cloud Certified - Professional Cloud Database Engineer certification is aimed at individuals who have experience in database administration, data management, and cloud computing. Professional-Cloud-Database-Engineer exam is designed to test your knowledge of Google Cloud Platform's database services, including Cloud SQL, Bigtable, and Spanner.

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.

Google Professional-Cloud-Database-Engineer certification is a valuable certification for database engineers and administrators who work with the Google Cloud Platform. It demonstrates a high level of expertise and knowledge in database management on the cloud, which is becoming increasingly important in today's digital landscape. Candidates can prepare for the exam by studying database management principles and gaining hands-on experience with database administration on the Google Cloud Platform.

 

NEW QUESTION # 51
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 sharded Cloud SQL instances with one or more stores per database instance.
• B. Use Cloud Spanner with a custom autoscaling solution.
• C. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
• D. Use a Biglable cluster with autoscaling.

Answer: A

NEW QUESTION # 52
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

• A. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
• B. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
• C. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
• D. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.

Answer: B

Explanation:
https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external

NEW QUESTION # 53
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. Ensure that the service account has the Storage Admin role.
• B. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
• C. Close idle connections or restart the instance before beginning the import operation.
• D. Increase the amount of memory allocated to your instance.

Answer: A

NEW QUESTION # 54
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

• A. Automate instance creation by writing a Dataflow job.
• B. Automate instance creation by setting up Terraform scripts.
• C. Create clones from a template Cloud SQL instance.
• D. Create the instances using the Google Cloud Console UI.

Answer: D

NEW QUESTION # 55
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

• A. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
• B. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
• C. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
• D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

Answer: A

Explanation:
"Read replicas do not have the cloudsql.iam_authentication flag enabled automatically when it is enabled on the primary instance." https://cloud.google.com/sql/docs/postgres/replication/create-replica#configure_iam_replicas

NEW QUESTION # 56
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. Ensure that you are using an external (public) IP address interface.
• B. Enable the Cloud SQL Admin API.
• C. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
• D. Check whether your service account has cloudsql.instances.connect permission.

Answer: B

Explanation:
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting C because in docs it says
"Make sure to enable the Cloud SQL Admin API. If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL

NEW QUESTION # 57
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. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
• B. Verify that the new replica is created automatically.
• 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: B

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 # 58
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. 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. Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.

Answer: C

NEW QUESTION # 59
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

• A. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
• B. Set up Traffic Director.
• C. Set up Private Service Connect.
• D. Set up Serverless VPC Access.

Answer: A

Explanation:
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%
20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.
&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.

NEW QUESTION # 60
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?

• A. Back up the database, create an instance with additional vCPUs, and restore the database.
• B. Update a MySQL database flag to increase the number of vCPUs.
• C. Issue a gcloud compute instances update command to increase the number of vCPUs.
• D. Issue a gcloud sql instances patch command to increase the number of vCPUs.

Answer: D

Explanation:
https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch

NEW QUESTION # 61
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS.
You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

• A. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
• B. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
• C. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
• D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

Answer: B

Explanation:
Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C.
https://cloud.google.com/compute/docs/disks/performance

NEW QUESTION # 62
Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?

• A. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
• B. Use Memorystore to handle your low-latency requirements and for real-time analytics.
• C. Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
• D. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.

Answer: A

Explanation:
Start with the lowest tier and smallest size and then grow your instance as needed. Memorystore provides automated scaling using APIs, and optimized node placement across zones for redundancy. Memorystore for Memcached can support clusters as large as 5 TB, enabling millions of QPS at very low latency

NEW QUESTION # 63
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

• A. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
• B. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
• C. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
• D. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

Answer: A

Explanation:
Use Firestore in Datastore mode for new server projects. Firestore in Datastore mode allows you to use established Datastore server architectures while removing fundamental Datastore limitations. Datastore mode can automatically scale to millions of writes per second. Use Firestore in Native mode for new mobile and web apps. Firestore offers mobile and web client libraries with real-time and offline features. Native mode can automatically scale to millions of concurrent clients.

NEW QUESTION # 64
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

• A. Use Cloud SQL instance monitoring in the Google Cloud Console.
• B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
• C. Use log messages produced by Cloud SQL.
• D. Use Query Insights for Cloud SQL.

Answer: B

NEW QUESTION # 65
You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

• A. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
• B. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
• C. Use the default configuration for the automated backups location.
• D. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Answer: A

NEW QUESTION # 66
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. Shard data required by the application into multiple instances.
• C. Increase the number of processing units.
• D. Decrease the number of processing units.

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 # 67
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

• A. Use replication from an external server to migrate the databases to Cloud SQL.
• B. Use a cross-region read replica to migrate the databases to Cloud SQL.
• C. Use Database Migration Service to migrate the databases to Cloud SQL.
• D. Use a read replica to migrate the databases to Cloud SQL.
• E. Use an external read replica to migrate the databases to Cloud SQL.

Answer: A,D

NEW QUESTION # 68
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

• A. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
• B. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
• C. Use Database Migration Service to migrate your database.
• D. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

Answer: B

Explanation:
PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database.
+ PgBouncer is a simple PostgreSQLconnection pool that allows for several thousand connections at a time.
Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech- industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank.https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max- connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%
20bank.

NEW QUESTION # 69
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

• A. Use Firestore.
• B. Use Cloud Spanner.
• C. Use Bigtable.
• D. Use Cloud SQL.

Answer: D

NEW QUESTION # 70
You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?

• A. Create your instance with a specified external (public) IP address.
  Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
  Connect to the instance using a connection pool to best manage connections to the instance.
• B. Create your instance with a specified internal (private) IP address.
  Choose the VPC with private service connection configured.
  Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
  Use Cloud SQL Auth proxy to connect to the instance.
• C. Create your instance with a specified internal (private) IP address.
  Choose the VPC with private service connection configured.
  Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
  Connect to the instance using a connection pool to best manage connections to the instance.
• D. Create your instance with a specified external (public) IP address.
  Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
  Use Cloud SQL Auth proxy to connect to the instance.

Answer: B

NEW QUESTION # 71
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

• A. Use Cloud Spanner in a regional configuration.
• B. Use Cloud Spanner in a multi-region configuration.
• C. Use highly available Cloud SQL with multiple zones.
• D. Use Cloud SQL with cross-region replicas.

Answer: A

Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform

NEW QUESTION # 72
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 source Amazon RDS for MySQL read replica.
• B. Create a single Database Migration Service migration job with initial Load Parallelism configured to Maximum on the Amazon RDS for MySQL primary instance.
• C. Create and start multiple Database Migration Service jobs to migrate your database to the target Cloud SQL for MySQL instance.
• D. 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.

Answer: A

NEW QUESTION # 73
......

View All Professional-Cloud-Database-Engineer Actual Free Exam Questions Updated: https://passguide.vce4dumps.com/Professional-Cloud-Database-Engineer-latest-dumps.html