A Database Engineer has been tasked with sizing a Cloud SQL instance based on the current environment workload metrics and future requirements. The current average workload metrics are as follows:5000 queries per second during peak times3 TB of data storage10,000 concurrent connections150 GB of backup storageThe company is expecting a 50% increase in workload and a 20% increase in data storage over the next year. Which of the following instance configurations is the most appropriate to handle the anticipated growth while minimizing costs?

D- db-n1-highmem-32 with 4 TB of SSD storage

A Database Engineer is evaluating different configurations for a Cloud SQL instance that will host a customer relationship management (CRM) application. The workload metrics and requirements are as follows:3,000 queries per second during peak times2 TB of data storage5,000 concurrent connections100 GB of backup storageThe engineer needs to choose a configuration that provides a balance between performance and cost. Which of the following instance configurations is the most appropriate to meet the application requirements?

D- db-n1-standard-16 with 2 TB of SSD storage

A Database Engineer is tasked with optimizing the cost and performance of a Cloud SQL instance running MySQL. The instance is used by an e-commerce application with a heavy read workload and occasionally experiences high latency during peak hours. Which of the following solutions should the engineer implement to best address this issue while optimizing cost and performance?

D- Create read replicas and distribute the read queries across them

Your company is planning to migrate a mission-critical application to Google Cloud Platform. This application requires a scalable and highly available database solution with a focus on strong consistency, low latency, and the ability to perform complex SQL queries. The database must also support multi-region replication for disaster recovery purposes. Which of the following database services should you choose to meet these requirements, and what replication and scaling configuration should you use?

D- Cloud Spanner with Multi-Region Instance and Interleaved Tables

A Database Engineer is working on a project that involves a content management system (CMS) with a large number of images and documents being uploaded and accessed by users. The application is currently using Cloud Storage for storing the content, and the engineer is tasked with optimizing cost and performance. Which of the following strategies should the engineer implement to best achieve these objectives?

D- Enable Object Lifecycle Management to automatically transition objects to lower-cost storage classes

You are managing a PostgreSQL instance on a Compute Engine virtual machine (VM). The application team reports occasional slow query performance but cannot identify a pattern. You need to collect detailed metrics and logs to troubleshoot and identify the slow queries without impacting the current workload. What should you do?

D- Enable the log_min_duration_statement flag in the PostgreSQL configuration file and review the logs in the instance.

As a Database Engineer, how can you minimize Cloud SQL instance expenditure with minimal effort when each developer and tester has their own instance for learning and experimentation purposes, and the team operates from Monday morning to Friday evening?

C- Implement a Cloud Function that starts and stops the Cloud SQL instances, and schedule its execution using Cloud Scheduler as needed.

Your organization has an existing application that just went viral. The application uses a Cloud SQL for PostgreSQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

D- Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

Your company's web application allows users to submit text feedback, which is then automatically analyzed for sentiment and categorized. The results are stored, and a monthly sentiment report is generated for product improvement discussions. You need to design a solution that is cost-effective and easy to maintain. What should you do?

D- Employ BigQuery to store feedback, use its ML capabilities for sentiment analysis, and BigQuery scheduled queries for monthly reporting.

Your organization relies on Cloud Spanner to store data for a mission-critical, user-facing application that requires low-latency read operations. You need to recommend the optimal instance configuration to ensure consistent, high-performance reads. What should you do?

B- Recommend using a regional instance with sufficient nodes to handle the application's read throughput requirements.

You are managing a Cloud Spanner database that needs to handle an increasing number of read and write operations due to the growing number of users. You want to optimize the performance and scalability of the database. What should you do? (Choose two)

A- Increase the number of nodes in the instance.; C- Use smaller transactions to reduce lock contention.

Professional Cloud Database Engineer - Google Cloud Certified Exam Questions

360

Total Questions

AUG

2026

Last Updated

1st

1st Try Guaranteed

Experts Verified

Preparing for the Google Cloud Certified Professional Cloud Database Engineer certification requires not only theoretical knowledge but also practical experience with real exam questions. This practice exam offers a unique opportunity to engage with 360 expertly crafted questions that align closely with the format and content of the actual certification exam. By taking this practice test, candidates can expose themselves to the types of scenarios and problem-solving tasks they will encounter, allowing them to assess their readiness and identify areas for further study.

The real-time feedback provided after each question enables a focused self-assessment, helping candidates pinpoint their strengths and weaknesses. This targeted approach not only enhances learning but also boosts confidence as they navigate the complexities of Google Cloud database solutions. By simulating the exam environment, candidates can develop effective test-taking strategies, manage their time, and ultimately increase their chances of success on the certification exam. Use this practice exam as a critical tool in your preparation journey, setting the stage for a thorough understanding of key topics and improving your overall performance.

Per page:

Welcome to the real exam questions-and-answers listing page for the Professional Cloud Database Engineer - Google Cloud Certified certification. Here, you will find a collection of 360 practice questions designed to help you assess your knowledge and readiness for the certification exam. Each question is crafted to reflect the types of scenarios and topics you might encounter on the actual exam, providing you with a targeted way to focus your studies.

To make the most of this resource, we recommend approaching the questions strategically. Start by taking a practice test to gauge your current understanding and identify areas where you need improvement. As you work through the questions, make sure to review any explanations provided to deepen your comprehension of the concepts.

For effective preparation, consider these study tips: First, create a structured study schedule that allocates time to different topics, ensuring you cover all relevant content thoroughly. Second, practice hands-on with Google Cloud services, as practical experience can significantly enhance your theoretical knowledge. Lastly, join study groups or online forums to discuss complex topics and gain insights from peers, which can improve your understanding and retention of material. By following these strategies, you'll be well-equipped to tackle the certification exam confidently.

Question 1 Multiple Choice

You are managing a Cloud SQL instance that is crucial for handling transactional data for your e-commerce platform. Customers have experienced performance degradation during high traffic periods due to resource contention and connection bottlenecks. You want to optimize database performance and resilience for future high-traffic scenarios. What should you do? (Choose two)

Question 2 Single Choice

You support a customer order management application that runs on a regional instance of Cloud SQL for PostgreSQL. A client 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?

Question 3 Single Choice

A Database Engineer has been asked to design a backup and recovery solution for a mission-critical database hosted on Google Cloud SQL. The database is expected to have a high rate of transactions and must have a low Recovery Point Objective (RPO) and Recovery Time Objective (RTO). Which of the following backup and recovery solutions would best meet these requirements?

Question 4 Single Choice

A Database Engineer has been tasked with sizing a Cloud SQL instance based on the current environment workload metrics and future requirements. The current average workload metrics are as follows:

5000 queries per second during peak times
3 TB of data storage
10,000 concurrent connections
150 GB of backup storage

The company is expecting a 50% increase in workload and a 20% increase in data storage over the next year. Which of the following instance configurations is the most appropriate to handle the anticipated growth while minimizing costs?

Question 5 Single Choice

You are managing a critical Cloud Spanner instance used by a high-traffic web application. Your development team is deploying a major update and requires a full database backup before proceeding. Another DBA starts an on-demand backup, and you need to verify the backup status. What should you do?

Question 6 Single Choice

You are a Database Engineer responsible for migrating a Cassandra database to Google Cloud Bigtable while ensuring minimal downtime and maintaining a fallback plan. Which of the following migration strategies is best for this scenario?

A- Create a Bigtable instance, use Bigtable's import functionality to convert the schema and transfer data, and set up a reverse replication from Bigtable to the on-premises Cassandra database as a fallback.

B- Develop custom scripts to convert the Cassandra schema to Bigtable and transfer the data using Bigtable APIs, then create a reverse replication process from Bigtable to the on-premises Cassandra database as a fallback plan.

C- Use Cloud Data Fusion to convert the Cassandra schema and transfer the data to Bigtable, then create a Cloud Data Fusion pipeline to transfer the data back to the on-premises database as a fallback plan.

D- Utilize the Schema Conversion Tool (SCT) to convert the Cassandra schema for Bigtable, perform data transfer using Dataflow, and set up a reverse replication from Bigtable to the on-premises Cassandra database as a fallback.

Question 7 Single Choice

A Database Engineer is evaluating different configurations for a Cloud SQL instance that will host a customer relationship management (CRM) application. The workload metrics and requirements are as follows:

3,000 queries per second during peak times
2 TB of data storage
5,000 concurrent connections
100 GB of backup storage

The engineer needs to choose a configuration that provides a balance between performance and cost. Which of the following instance configurations is the most appropriate to meet the application requirements?

Question 8 Single Choice

As a Database Engineer, you are required to test disaster recovery strategies periodically for a mission-critical application. Which of the following options is the best method to conduct a disaster recovery test while minimizing the impact on production workloads and ensuring high fidelity test results?

Question 9 Single Choice

Your company's Cloud SQL for PostgreSQL database has been experiencing intermittent slow-downs due to an unknown issue. As a database administrator, you want to establish a mechanism to quickly identify the cause when it happens again. What should you do?

Question 10 Single Choice

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 401: Unauthorized. What should you do?

Page: 1 / 36

Frequently Asked Questions

How realistic are the practice questions for the Professional Cloud Database Engineer exam?

The practice questions are designed to closely mimic the format and content of the actual exam questions, helping you become familiar with the topics and question styles you'll encounter.

What is the best way to use the practice exam questions to prepare?

Review each question thoroughly, understand the reasoning behind the correct answers, and identify your weak areas to focus your studies for better preparation.

How many practice questions should I complete before taking the real exam?

It's recommended to complete a significant portion, ideally all 360 practice questions, to ensure comprehensive coverage of the material and to build confidence before the actual exam.

Can I track my progress while taking the practice exam questions?

Yes, most practice exam platforms provide score tracking and analytics, allowing you to monitor your performance and identify areas for improvement over time.

Are there any specific topics I should focus on while practicing?

While all topics are important, pay extra attention to areas where you feel less confident based on your performance in the practice questions.