[2026] New Professional-Cloud-Database-Engineer exam dumps Use Updated Google Exam [Q26-Q49]

Rate this post

[2026] New Professional-Cloud-Database-Engineer exam dumps Use Updated Google Exam

Verified Professional-Cloud-Database-Engineer Dumps Q&As – Professional-Cloud-Database-Engineer Test Engine with Correct Answers

Google Professional-Cloud-Database-Engineer Exam Syllabus Topics:

Section	Objectives
Topic 1: Manage a database solution spanning multiple systems	– Operational database management 1. Monitoring and performance tuning 2. Capacity planning and scaling 3. Backup and restore strategies
Topic 2: Ensure reliability, performance, and optimization	– Performance optimization 1. Workload tuning across database services 2. Indexing, query optimization, and caching strategies – Security and compliance 1. Encryption at rest and in transit 2. IAM roles and access control
Topic 3: Design scalable and highly available database solutions	– Select appropriate database services (relational, NoSQL, analytical) 1. Firestore and document database patterns 2. Bigtable use cases and schema design 3. Cloud SQL vs AlloyDB vs Spanner selection criteria – Design for high availability and disaster recovery 1. Regional vs multi-regional architectures 2. Replication strategies and failover design
Topic 4: Migrate data solutions to Google Cloud	– Database migration strategies 1. Lift-and-shift vs re-platforming 2. Online vs offline migration tools (e.g., Database Migration Service)

NEW QUESTION 26
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?

Reuse the existing service account that populates this database.

Create a new service account, and grant it the Cloud Spanner Database Admin role.

Create a new service account, and grant it the Cloud Spanner Database Reader role.

Create a new service account, and grant it the spanner.databases.select permission.

NEW QUESTION 27
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?

Watch Query Insights for long running queries.

Watch the Cloud SQL instance monitor for CPU utilization metrics.

Watch the Cloud SQL recommenders for overprovisioned instances.

Watch Cloud Trace for application requests that are failing.

NEW QUESTION 28
Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

Set Terraform deletion_protection to true.

Rerun terraform apply.

Create a read replica.

Use point-in-time-recovery (PITR) to recover the database.

NEW QUESTION 29
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?

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

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

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

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

NEW QUESTION 30
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?

Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

Edit the instance to change the storage type from HDD to SSD.

Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

Create a read replica of the instance with SSDs, and perform a failover to the new instance

NEW QUESTION 31
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?

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.

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.

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.

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.

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

Apply a schema data management pattern.

Apply an instance data management pattern.

Apply a table data management pattern.

Apply a database data management pattern.

NEW QUESTION 33
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest dat a. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

Create a read replica for the Sales Reporting application.

Create two separate databases in the instance, and perform dual writes from the Order Management application.

Use a Cloud SQL federated query for the Sales Reporting application.

Queue up all the requested reports in PubSub, and execute the reports at night.

NEW QUESTION 34
Your e-learning platform runs on a Cloud SQL for PostgreSQL instance (16 VCPUs, 60 GB memory and 1TB SSD) serving users in North America. Your analytics team runs complex reporting queries that often consume 80% of CPU resources, causing slow response times for student transactions during peak hours. Current workload includes 8,000 transactions per second with 60% reads and 40% writes. The reporting queries involve JOIN operations across multiple large tables with millions of rows requiring highly efficient analytical processing. The platform also experiences sudden spikes in analytical reporting demand, requiring an elastic scaling of read capacity. You need to improve the query performance for your analytics team to run their reports efficiently without impacting transactional users. You also need to plan for future traffic growth.
What should you do-

Upgrade to Cloud SAL for PostgreSQL Enterprise Edition and route transaction and analytical queries to the primary instance.

Migrate to AlloyDB for PostgreSQL and upgrade the machine type of the primary instance to 32 vCPU. Create materialized views for common analytical queries.

Migrate to AlloyDB for PostgreSQL with a 16 vCPU primary instance and enable columnar engine for analytical workloads, using read pools for query isolation.

Upgrade the Cloud SQL for PostgreSQL instance to db-n1-highmem-32and implement connection pooling with PgBouncerto handle increased load.

NEW QUESTION 35
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?

Use query parameters to speed up frequently executed queries.

Change the Cloud Spanner configuration from multi-region to single region.

Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

NEW QUESTION 36
You migrated a large, query-intensive data warehouse from an on-premises PostgreSQL setup to AlloyDB. Initial performance after the migration is acceptable, but you want to optimize for even faster analytical queries while being cost-effective.
What should you do?

Use Query Insights to optimize query performance and the data model for AlloyDB’s columnar storage.

Increase the number of compute nodes for AlloyDB to maximize parallelization and raw processing power.

Focus on client-side query optimization in the reporting tool.

Migrate to BigQuery for transactional workloads.

NEW QUESTION 37
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?

Normalize the database to the third normal form.

Compress the data using a different compression algorithm.

Manually or automatically increase the storage capacity.

Create another schema to load older data.

NEW QUESTION 38
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?

Migrate the Oracle databases to Cloud Spanner.

Migrate the Oracle databases to Compute Engine.

Migrate the Oracle databases to Cloud SQL.

Migrate the Oracle databases to Bare Metal Solution for Oracle.

NEW QUESTION 39
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?

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.

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

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.

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.

NEW QUESTION 40
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency.
What should you do?

Use linear scaling to implement the Autoscaler-based architecture

Use direct scaling to implement the Autoscaler-based architecture.

Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

NEW QUESTION 41
You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non- mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do?

Increase the size of the read replica Instance and enable MA.

Enable HA on the current read replica.

Create a new HA instance in the same zone db lie primary.

Create a new MA Instance in a different region than the primary.

NEW QUESTION 42
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

Increase the number of processing units.

Modify the database schema, and add additional indexes.

Shard data required by the application into multiple instances.

Decrease the number of processing units.

NEW QUESTION 43
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

NEW QUESTION 44
You are running a mission-critical application on Google Kubernetes Engine (GKE) and you are using private IP to connect to Cloud SQL for PostgreSQL in us-central1. You want to maximize database uptime without making any major changes to the application in case of a planned event, such as maintenance. What should you do-

Enable Automated backups and configure the retention period to 365 days.

Create a cross-region read replica in us-south1.

Upgrade to the Cloud SAL Enterprise Plus edition.

Set up notifications about upcoming maintenance sent to your email at least one week before maintenance is scheduled.

NEW QUESTION 45
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

Create a read replica in another region, and promote the read replica if a failure occurs.

Enable high availability (HA) for the database to make it regional.

NEW QUESTION 46
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?

Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).

Migrate applications and Oracle databases to Compute Engine.

Migrate applications to Cloud SQL.

Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).

NEW QUESTION 47
You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?

Use Cloud SQL for PostgreSQL with both cross-region read replicas.

Use Cloud Spanner in a multi-region configuration.

Use Firestore in Datastore mode.

Use a Bigtable instance with clusters in multiple regions.

NEW QUESTION 48
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?

Use Firestore.

Use Cloud Spanner.

Use Cloud SQL.

Use Bigtable.

NEW QUESTION 49
You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

Use Cloud SQL instance monitoring.

Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

Use Cloud SQL logs.

Use the SQL Server Always On Availability Group dashboard.