1. Home
  2. Google
  3. PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Practice Questions and Exam Preparation

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Details

  • Exam Code
    :PROFESSIONAL-CLOUD-DATABASE-ENGINEER
  • Exam Name
    :Google Cloud Certified - Professional Cloud Database Engineer
  • Certification
    :Google Certifications
  • Vendor
    :Google
  • Total Questions
    :132 Q&As
  • Last Updated
    :Jul 08, 2026

Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Questions & Answers

  • Question 31:

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

  • Question 32:

    Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?

    A. Use Cloud Spanner instead of Cloud SQL.
    B. Increase the number of CPUs for your instance.
    C. Increase the storage size for the instance.
    D. Use many smaller Cloud SQL instances.

  • Question 33:

    Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

    A. Migrate the Oracle databases to Cloud Spanner.
    B. Migrate the Oracle databases to Compute Engine.
    C. Migrate the Oracle databases to Cloud SQL.
    D. Migrate the Oracle databases to Bare Metal Solution for Oracle.

  • Question 34:

    Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL 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?

    A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
    B. Edit the instance to change the storage type from HDD to SSD.
    C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
    D. Create a read replica of the instance with SSDs, and perform a failover to the new instance

  • Question 35:

    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. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
    B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
    C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
    D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

  • Question 36:

    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 Firestore.
    B. Migrate the existing database to Cloud SQL for PostgreSQL.
    C. Migrate the existing database to Cloud Spanner.
    D. Migrate the existing database to PostgreSQL running on Compute Engine.

  • Question 37:

    You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

    A. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
    B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
    C. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
    D. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

  • Question 38:

    Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

    A. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL. Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination. Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.
    B. Create migration job using Database Migration Service. Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode. Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete. Update your application connections to the new instance.
    C. Create migration job using Database Migration Service. Set the migration job type to One-time, and perform this migration during a maintenance window. Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database. Update your application connections to the new instance.
    D. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window. Move the files to Cloud Storage, and import each database into your Cloud SQL instance. Continue to dump each database until all the databases are migrated. Update your application connections to the new instance.

  • Question 39:

    You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

    A. Bring DB-1 back online.
    B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
    C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
    D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

  • Question 40:

    Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?

    A. Use workload identity federation to impersonate a service account.
    B. Ask existing users to set their Google password to match their corporate password.
    C. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
    D. Use Google Workspace Password Sync to replicate passwords into Google Cloud.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Google exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam preparations and Google certification application, do not hesitate to visit our Vcedump.com to find your solutions here.