The Best Professional-Cloud-Database-Engineer Exam Study Material Premium Files and Preparation Tool (Mar-2026)
Get Instant Access to Professional-Cloud-Database-Engineer Practice Exam Questions
Google Professional-Cloud-Database-Engineer certification exam is a valuable credential for database professionals who want to demonstrate their expertise in managing cloud-native database solutions on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam is challenging, but passing it signifies that the candidate has a deep understanding of Google Cloud Platform's database services and can design, develop, and manage cloud-native database solutions with confidence.
NEW QUESTION # 24
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
- A. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
- B. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
- C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
- D. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
Answer: A
NEW QUESTION # 25
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
- A. Set up a Cloud NAT gateway on the Compute Engine VM.
- B. Setup a static external IP address in your VPC network.
- C. Set up bring your own IP (BYOIP) in your VPC.
- D. Set up Cloud NAT service.
Answer: A
Explanation:
https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat The docs specifically says "Setting up a NAT gateway on a Compute Engine VM" is the way to give BMS internet access.
NEW QUESTION # 26
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 Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
- B. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
- C. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- 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: A
NEW QUESTION # 27
You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?
- A. Use interleaving to co-locate parent and child rows.
- B. Manually scale down the number of nodes after the peak period has passed.
- C. Use granular instance sizing in Cloud Spanner and Autoscaler.
- D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
Answer: D
NEW QUESTION # 28
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 Serverless VPC Access.
- B. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- C. Set up Traffic Director.
- D. Set up Private Service Connect.
Answer: B
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 # 29
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. Create clones from a template Cloud SQL instance.
- B. Create the instances using the Google Cloud Console UI.
- C. Automate instance creation by writing a Dataflow job.
- D. Automate instance creation by setting up Terraform scripts.
Answer: D
NEW QUESTION # 30
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
- A. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
- B. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
- C. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
- D. Create a VM in Compute Engine, and run a cron job.
Answer: A
NEW QUESTION # 31
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?
- A. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- B. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- C. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
- D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
Answer: A
NEW QUESTION # 32
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. Shard data required by the application into multiple instances.
- B. Decrease the number of processing units.
- C. Modify the database schema, and add additional indexes.
- D. Increase the number of processing units.
Answer: D
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 # 33
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 Firestore in Datastore mode.
- B. Use Cloud Spanner in a multi-region configuration.
- C. Use Cloud SQL for PostgreSQL with both cross-region read replicas.
- D. Use a Bigtable instance with clusters in multiple regions.
Answer: B
Explanation:
https://cloud.google.com/blog/products/databases/manage-semi-structured-data-in-cloud-spanner-with-json
NEW QUESTION # 34
You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?
- A. Use Cloud SQL federated queries.
- B. Use Identity and Access Management (IAM) authentication.
- C. Use PostgreSQL database's built-in authentication.
- D. Use Managed Active Directory authentication.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/postgres/authentication
NEW QUESTION # 35
Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?
- A. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
- B. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
- C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
- D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
Answer: C
Explanation:
https://www.actifio.com/solutions/cloud/google/
NEW QUESTION # 36
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?
- A. Apply a table data management pattern.
- B. Apply a database data management pattern.
- C. Apply a schema data management pattern.
- D. Apply an instance data management pattern.
Answer: D
NEW QUESTION # 37
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 common shared user account.
- B. For the application server, set up a common shared user account.
- C. For the application server, set up a service account.
- D. For each application code, set up a dedicated user account.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account
NEW QUESTION # 38
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?
- A. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
- B. Enable high availability (HA) for the database to make it regional.
- C. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
- D. Create a read replica in another region, and promote the read replica if a failure occurs.
Answer: B
NEW QUESTION # 39
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
- A. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
- B. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
- C. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- D. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
Answer: B
NEW QUESTION # 40
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. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- B. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- C. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
- D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Answer: C
NEW QUESTION # 41
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Composer to execute a select * from table(s) query and export results.
- B. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
- C. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
- D. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
Answer: C
NEW QUESTION # 42
Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?
- A. Select Cloud SQL.
- B. Select Bigtable.
- C. Select Cloud Spanner.
- D. Select Bare Metal Solution for Oracle.
Answer: C
Explanation:
The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases.
NEW QUESTION # 43
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?
- A. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
- B. Use Bigtable, and add nodes as necessary to achieve the required throughput.
- C. Use Cloud SQL with read replicas for throughput.
- D. Use Firestore, and rely on automatic serverless scaling.
Answer: B
Explanation:
https://cloud.google.com/memorystore/docs/redis/redis-overview
NEW QUESTION # 44
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: D
NEW QUESTION # 45
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
- A. Migrate the existing database to Cloud SQL for PostgreSQL.
- B. Migrate the existing database to Firestore.
- C. Migrate the existing database to Cloud Spanner.
- D. Migrate the existing database to PostgreSQL running on Compute Engine.
Answer: A
NEW QUESTION # 46
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 Cloud Spanner with default encryption.
- B. Use Cloud SQL with a customer-managed encryption key (CMEK).
- C. Use Bigtable with default encryption.
- D. Use Cloud Spanner with a customer-managed encryption key (CMEK).
Answer: B
NEW QUESTION # 47
......
Validate your Skills with Updated Professional-Cloud-Database-Engineer Exam Questions & Answers and Test Engine: https://pass4sure.actual4cert.com/Professional-Cloud-Database-Engineer-pass4sure-vce.html