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

    You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

    A. Reuse the existing service account that populates this database.
    B. Create a new service account, and grant it the Cloud Spanner Database Admin role.
    C. Create a new service account, and grant it the Cloud Spanner Database Reader role.
    D. Create a new service account, and grant it the spanner.databases.select permission.

  • Question 42:

    Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

    A. Use Firestore.
    B. Use Cloud Spanner.
    C. Use Cloud SQL.
    D. Use Bigtable.

  • Question 43:

    You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

    A. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
    B. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
    C. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
    D. Use Cloud Composer to execute a select * from table(s) query and export results.

  • Question 44:

    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 403: Access Not Configured. What should you do?

    A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
    B. Check whether your service account has cloudsql.instances.connect permission.
    C. Enable the Cloud SQL Admin API.
    D. Ensure that you are using an external (public) IP address interface.

  • Question 45:

    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?

    A. Use Logs Explorer to analyze log data.
    B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
    C. Use Error Reporting to count, analyze, and aggregate the data.
    D. Use Cloud Debugger to inspect the state of an application.

  • Question 46:

    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?

    A. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
    B. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
    C. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
    D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

  • Question 47:

    You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

    A. Drop or disable all users except database administration users.
    B. Disable all foreign key constraints on the source PostgreSQL database.
    C. Ensure that all PostgreSQL tables have a primary key.
    D. Shut down the database before the Data Migration Service task is started.
    E. Ensure that pglogical is installed on the source PostgreSQL database.

  • Question 48:

    You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

    A. Set the automated backups to occur every other day to lower the frequency of backups.
    B. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
    C. Select a different region to store your backups.
    D. Reduce the number of automated backups that are retained to two (2).

  • Question 49:

    You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

    A. For each application code, set up a common shared user account.
    B. For each application code, set up a dedicated user account.
    C. For the application server, set up a service account.
    D. For the application server, set up a common shared user account.

  • Question 50:

    Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

    A. Normalize the database to the third normal form.
    B. Compress the data using a different compression algorithm.
    C. Manually or automatically increase the storage capacity.
    D. Create another schema to load older data.

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.