Free Google Professional Cloud Database Engineer practice questions

10 free Google Professional Cloud Database Engineer practice questions with the correct answer and a full explanation for each, taken from the CertStash pack of 197 questions. Work through them, then open each answer to check your reasoning.

Get all 197 questions (US$39) · Download these 10 as a PDF

Question 1

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?

  1. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
  2. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
  3. 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.
  4. 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.
Show answer and explanation

Correct answer: C. 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.

proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance. Cloud SQL Auth proxy is the Google-recommended approach for secure database connectivity. It handles authentication via service accounts, encrypts connections, and works with both public and private IP addresses. Using the private IP address (192.168.3.48) with Auth proxy requires no database configuration changes and provides the most secure, managed connection method. The Auth proxy manages all credential handling transparently to the application.

Why the other options are wrong

  • A. Using Google username and password is insecure and not a supported authentication method for JDBC connections to Cloud SQL.
  • B. While a direct connection to the private IP with database credentials might work, it bypasses Cloud SQL Auth proxy security benefits and doesn't follow Google- recommended practices.
  • D. Auth proxy should point to the private IP address, not the public IP address, to maintain security within the internal network.

Question 2

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices.

What should you do? (Choose two.)

  1. Set up manual backups.
  2. Create a PostgreSQL database on-premises as the HA option.
  3. Configure single zone availability for automated backups.
  4. Enable point-in-time recovery.
  5. Schedule automated backups.
Show answer and explanation

Correct answer: D, E

D. Enable point-in-time recovery. E. Schedule automated backups. Point-in-time recovery (D) enables restoration to any specific point in time, which is essential for HA and disaster recovery scenarios. Scheduled automated backups (E) ensure regular, consistent backup creation without manual intervention, supporting 24/7 availability requirements. These two practices combined provide both preventive backup coverage and recovery flexibility needed for global 24/7 uptime. Manual backups lack automation, single zone availability contradicts HA best practices, and on-premises alternatives defeat the cloud migration purpose.

Why the other options are wrong

  • A. Manual backups are unreliable and don't scale for 24/7 global operations requiring consistent protection.
  • B. On-premises HA options contradict the goal of moving to Google Cloud and complicate management.
  • C. Single zone availability is the opposite of HA best practices; multi-zone or multi- region configurations are required for high availability.

Question 3

Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud.

What should you do?

  1. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
  2. Migrate applications and Oracle databases to Compute Engine.
  3. Migrate applications to Cloud SQL.
  4. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
Show answer and explanation

Correct answer: A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).

Cloud VMware Engine (VMware Engine). Google Cloud VMware Engine is purpose-built for migrating VMware-based workloads with minimal architectural changes. It allows the Oracle application and databases to run in a familiar VMware environment on Google Cloud infrastructure, preserving the existing architecture while eliminating the need for extensive refactoring. This provides the fastest migration path with minimal disruption during the six-month datacenter closure timeline.

Why the other options are wrong

  • B. Compute Engine would require significant application and database refactoring, contradicting the minimal disruption requirement.
  • C. Cloud SQL is designed for managed relational databases, not for running Oracle applications with their VMware infrastructure dependencies.
  • D. GKE containerization would require substantial redesign and refactoring of the entire Oracle application footprint.

Question 4

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency.

What should you do?

  1. Use query parameters to speed up frequently executed queries.
  2. Change the Cloud Spanner configuration from multi-region to single region.
  3. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
  4. Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
Show answer and explanation

Correct answer: C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

SPANNER_SYS.READ_STATS* tables. SPANNER_SYS.READ_STATS tables provide detailed metrics on read operations including latency, throughput, and execution details. Since high read latency was observed, analyzing these statistics reveals which queries or operations are causing the degradation and where optimization is needed. This allows targeted troubleshooting to identify the root cause introduced in the new application version.

Why the other options are wrong

  • A. Query parameters optimize query execution but don't diagnose the root cause of existing latency problems.
  • B. Changing from multi-region to single region would increase latency for global users, worsening rather than solving the problem.
  • D. QUERY_STATS tables focus on query execution patterns but READ_STATS specifically targets read operation latency issues.

Question 5

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy.

What should you do?

  1. Use Database Migration Service to migrate all databases to Cloud SQL.
  2. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
  3. Use data replication tools and CDC tools to enable migration.
  4. Use a combination of Database Migration Service and partner tools to support the data migration strategy.
Show answer and explanation

Correct answer: A. Use Database Migration Service to migrate all databases to Cloud SQL.

databases to Cloud SQL. Database Migration Service is Google's native tool specifically designed for migrating databases to Cloud SQL. It supports both one-time migrations and continuous CDC-style replication, handles heterogeneous sources like PostgreSQL and AWS databases, and provides comprehensive monitoring during cutover. Using the native Google tool exclusively follows best practices, simplifies the migration strategy, and provides integrated monitoring and management without relying on third-party tools.

Why the other options are wrong

  • B. Database Migration Service supports CDC-style migrations natively, eliminating the need for third-party tools and reducing complexity.
  • C. Relying solely on generic data replication and CDC tools without Google's native service lacks integrated monitoring and support.
  • D. Mixing multiple tools unnecessarily complicates the migration strategy when Database Migration Service alone is sufficient and recommended.

Question 6

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?

  1. Setup a static external IP address in your VPC network.
  2. Set up bring your own IP (BYOIP) in your VPC.
  3. Set up a Cloud NAT gateway on the Compute Engine VM.
  4. Set up Cloud NAT service.
Show answer and explanation

Correct answer: D. Set up Cloud NAT service.

Cloud NAT service provides Network Address Translation for Bare Metal Solution environments to access the internet for software updates and patches. Cloud NAT translates internal IP addresses to external addresses, allowing outbound internet connectivity without exposing individual machines. This is the recommended Google Cloud approach for enabling internet access from Bare Metal Solution for receiving updates.

Why the other options are wrong

  • A. Static external IP addresses are typically assigned to individual compute resources, not the appropriate mechanism for Bare Metal Solution internet access.
  • B. BYOIP (Bring Your Own IP) is for importing customer IP ranges into GCP, not for enabling outbound internet access.
  • C. Cloud NAT on a Compute Engine VM is an indirect workaround; Cloud NAT service is the native, recommended solution for Bare Metal Solution.

Question 7

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation.

What should you do?

  1. Use Logs Explorer to analyze log data.
  2. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
  3. Use Error Reporting to count, analyze, and aggregate the data.
  4. Use Cloud Debugger to inspect the state of an application.
Show answer and explanation

Correct answer: B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

storage utilization metrics. Cloud Monitoring provides real-time metrics for CPU, memory, storage, and database- specific performance indicators that directly correlate with performance degradation. When MySQL performance suddenly decreases, monitoring utilization metrics reveals whether the issue stems from resource bottlenecks, connection limits, or query overload. This is the standard first step in identifying the root cause of database performance problems.

Why the other options are wrong

  • A. Logs Explorer analyzes application and system logs but doesn't provide the performance metrics needed to identify resource utilization issues.
  • C. Error Reporting is designed for application error tracking and aggregation, not for identifying performance bottlenecks.
  • D. Cloud Debugger inspects application state during execution but is not designed for database performance analysis.

Question 8

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?

  1. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
  2. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
  3. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
  4. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Show answer and explanation

Correct answer: B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

and place your compute resources close to the default leader region. Cloud Spanner is purpose-built for globally distributed, transactional workloads requiring low latency, consistency, and relational schema support. A multi-region instance provides automatic failover and read scalability across geographic regions while maintaining ACID compliance. Placing compute resources near the default leader region minimizes latency for writes. This architecture handles the retail/ecommerce transaction requirements of global scale with transaction support and relational schema preservation.

Why the other options are wrong

  • A. Firestore is document-based and not optimized for relational schemas or complex transactional consistency required for sales and inventory.
  • C. Memorystore is an in-memory cache, not a primary transactional storage layer, and cannot replace relational database functionality.
  • D. Bigtable is a wide-column NoSQL database that sacrifices relational schema and transactions, unsuitable for maintaining existing schemas.

Question 9

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users.

What should you do?

  1. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting nonproduction instances to earlier and production instances to later.
  2. Create your database with one primary node and one read replica in the region.
  3. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
  4. Configure your Cloud SQL instance with high availability enabled.
Show answer and explanation

Correct answer: A. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting nonproduction instances to earlier and production instances to later.

when no users will be on the system. Control the order of update by setting nonproduction instances to earlier and production instances to later. Configuring a maintenance window during off-peak hours (outside 6 AM to 10 PM when users are active) ensures zero downtime for the application. By scheduling nonproduction instances earlier and production instances later, you maintain control over the update process and allow time to verify updates in nonproduction environments before production deployment. This approach satisfies the availability requirement while ensuring regular maintenance occurs.

Why the other options are wrong

  • B. Read replicas provide high availability and read scaling but do not prevent maintenance downtime on the primary instance.
  • C. Sending notifications does not prevent downtime; maintenance still causes unavailability during the scheduled window.
  • D. High availability in Cloud SQL provides automatic failover but still requires maintenance windows that cause brief unavailability.

Question 10

Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between

your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag.

What should you do?

  1. Identify and optimize slow running queries, or set parallel replication flags.
  2. Stop all running queries, and re-create the replicas.
  3. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
  4. Edit the primary instance to add additional memory.
Show answer and explanation

Correct answer: A. Identify and optimize slow running queries, or set parallel replication flags.

parallel replication flags. Replication lag occurs when the replica cannot keep up with write operations on the primary. Identifying and optimizing slow-running queries reduces the write load that the replica must process, directly addressing the lag. Parallel replication flags improve the replica's ability to apply changes concurrently. These solutions target the root cause of high replication lag without unnecessary infrastructure changes or service disruption.

Why the other options are wrong

  • B. Stopping queries and recreating replicas does not address the underlying cause and causes unnecessary downtime and data loss.
  • C. Increasing disk and vCPU on the primary addresses throughput but does not solve replication lag, which is about the replica's catch-up speed.
  • D. Adding memory to the primary does not directly improve the replica's ability to apply changes and process replication events.

That was 10 of 197.

The full Google Professional Cloud Database Engineer pack has all 197 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. US$39, paid once, with free monthly updates and a pass-or-your-money-back guarantee.

Get the full pack