NEW 2025 Certification Sample Questions Professional-Cloud-Database-Engineer Dumps & Practice Exam [Q20-Q36]

5/5 - (1 vote)

NEW 2025 Certification Sample Questions Professional-Cloud-Database-Engineer Dumps & Practice Exam

Professional-Cloud-Database-Engineer Deluxe Study Guide with Online Test Engine

Google Professional-Cloud-Database-Engineer certification is highly valued in the industry, as it demonstrates the candidate’s expertise in GCP database services. Google Cloud Certified – Professional Cloud Database Engineer certification is recognized globally, and it is considered to be one of the most sought-after certifications in the cloud database engineering domain. Google Cloud Certified – Professional Cloud Database Engineer certification provides the candidate with a competitive edge in the job market and opens up new career opportunities in the field of cloud database engineering.

NO.20 You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:
Can read tables, views, and DDL
Can write rows to the tables
Can add columns and indexes
Cannot drop the database
What should you do?

Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.

Assign the Cloud Spanner Database Admin role.

Assign the Cloud Spanner Database User role.

Assign the Cloud Spanner Admin role.

NO.21 You are migrating a telehealth care company’s on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.

Set up different organizations for each database type, and apply policy constraints at the organization level.

Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.

Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

NO.22 Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

NO.23 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.

NO.24 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?

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.

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.

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.

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.

NO.25 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?

Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.

Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.

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.

Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

NO.26 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.

NO.27 You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

Take no backups, and turn off transaction log retention.

Take one manual backup per day, and turn off transaction log retention.

Turn on automated backup, and turn off transaction log retention.

Turn on automated backup, and turn on transaction log retention.

NO.28 Your team is building an application that stores and analyzes streaming time series financial dat a. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?

Use Firestore.

Use Bigtable

Use BigQuery.

Use Cloud Spanner.

NO.29 Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

Isolate the data analysts and operations user groups to use different Bigtable instances.

Check the Cloud Monitoring table/bytes_used metric from Bigtable.

Use Key Visualizer for Bigtable.

Add more nodes to the Bigtable cluster.

NO.30 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 dat a. 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?

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

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

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

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

NO.31 Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database.
Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us- central1 and the backup region of us-east1. What should you do?

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-west1-b.
Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-central1-b.
Create a read replica in us-east1-b.

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east-b.
Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east1-b.
Create a read replica in us-central1-b.

NO.32 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.

NO.33 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.

NO.34 You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

Use Firestore and ensure that the PersistenceEnabled option is set to true.

Use Memorystore for Memcached.

Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

NO.35 You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

Disable and remove the internal IP address assignment.

Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.

Specify an authorized network with the CIDR range of the VM.

Disable and remove the external IP address assignment.

NO.36 Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

Cloud SQL

BigQuery

Cloud Spanner

Bigtable