CertsPoint
Sign In Get Started
See all results for ""
Exams About Us
Sign In Get Started
Exam Overview
Exam Code Professional-Cloud-Database-Engineer
Exam Name Google Professional Cloud Database Engineer
Vendor Google
Total Questions 141
Last Updated 26-Oct, 2026
Free Professional-Cloud-Database-Engineer Questions Get Premium Access
Why CertsPoint?
  • Latest & Verified Questions
  • Detailed Explanations
  • Regular Updates
  • Full-Length Practice Tests
  • Boost Your Exam Confidence

PDF Study Materials

Downloadable guides and resources

Practice Tests

Full-length tests with real exam experience

Progress Tracking

Monitor your performance and improvement

Study Anywhere

Access on desktop, tablet, and mobile

Excellent
4.6 (398 Up Votes)
Secure Payment Privacy Protected Money Back Guarantee

Free Professional-Cloud-Database-Engineer Practice Questions

Explore 6 free practice questions for the Google Professional-Cloud-Database-Engineer exam and review the answers and explanations to support your preparation.

  1. Question 1

    Single answer

    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?

    • Option A:

      Use Cloud Spanner in a regional configuration.

      Correct
    • Option B:

      Use Cloud Spanner in a multi-region configuration.

      Correct
    • Option C:

      Use Cloud SQL with cross-region replicas.

      Correct
    • Option D:

      Use highly available Cloud SQL with multiple zones.

      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: A

    Explanation

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

  2. Question 2

    Single answer

    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?

    • Option A:

      Setup a static external IP address in your VPC network.

      Correct
    • Option B:

      Set up bring your own IP (BYOIP) in your VPC.

      Correct
    • Option C:

      Set up a Cloud NAT gateway on the Compute Engine VM.

      Correct
    • Option D:

      Set up Cloud NAT service.

      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: C

    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.

  3. Question 3

    Single answer

    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 data. 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?

    • Option A:

      Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

      Correct
    • Option B:

      Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

      Correct
    • Option C:

      Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

      Correct
    • Option D:

      Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: D

    Explanation

    Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria

  4. Question 4

    Single answer

    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?

    • Option A:

      Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

      Correct
    • Option B:

      Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

      Correct
    • Option C:

      Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

      Correct
    • Option D:

      Shut down your existing Cloud SQL for MySQL instance, and enable HA.

      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: C

    Explanation

    Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.

    The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.

    By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.

  5. Question 5

    Single answer

    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?

    • Option A:

      Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

      Correct
    • Option B:

      Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

      Correct
    • Option C:

      Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

      Correct
    • Option D:

      Shut down your existing Cloud SQL for MySQL instance, and enable HA.

      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: C

    Explanation

    Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.

    The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.

    By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.

  6. Question 6

    Multiple answers

    You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

    • Option A:

      Use a change data capture (CDC) migration strategy.

      Correct
    • Option B:

      Move the physical database servers from on-premises to Google Cloud.

      Correct
    • Option C:

      Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.

      Correct
    • Option D:

      Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.


      Correct
    • Option E:

      Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: A, E

    Explanation

    https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer