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 51:

    You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

    A. Use Cloud Functions to run the export in Avro format.
    B. Use Cloud Functions to run the export in text format.
    C. Use Dataflow to run the export in Avro format.
    D. Use Dataflow to run the export in text format.

  • Question 52:

    Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective

    architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes.

    What should you do?

    A. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Keep backups older than one day stored in Actifio OnVault storage.
    B. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Keep backups older than one day stored in Actifio OnVault storage.
    C. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
    D. Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.

  • Question 53:

    You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

    A. Use the default app profile with single-cluster routing.
    B. Use the default app profile with multi-cluster routing.
    C. Create a custom app profile with multi-cluster routing.
    D. Create a custom app profile with single-cluster routing.

  • Question 54:

    You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

    A. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
    B. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
    C. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
    D. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

  • Question 55:

    You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

    A. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
    B. If the corruption is significant, perform a stale read and specify a recovery timestamp.Write the results back.
    C. If the corruption is significant, use import and export.
    D. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
    E. If the corruption is insignificant, perform a stale read and specify a recovery timestamp.Write the results back.

  • Question 56:

    You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

    A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
    B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
    C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
    D. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

  • Question 57:

    Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

    A. Watch Query Insights for long running queries.
    B. Watch the Cloud SQL instance monitor for CPU utilization metrics.
    C. Watch the Cloud SQL recommenders for overprovisioned instances.
    D. Watch Cloud Trace for application requests that are failing.

  • Question 58:

    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 data. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

    A. Apply a schema data management pattern.
    B. Apply an instance data management pattern.
    C. Apply a table data management pattern.
    D. Apply a database data management pattern.

  • Question 59:

    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 a Shared VPC, configure multiple service projects, and create firewall rules.
    B. Set up Serverless VPC Access.
    C. Set up Private Service Connect.
    D. Set up Traffic Director.

  • Question 60:

    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?

    A. Identify and optimize slow running queries, or set parallel replication flags.
    B. Stop all running queries, and re-create the replicas.
    C. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
    D. Edit the primary instance to add additional memory.

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.