[Dec 31, 2025] Free Google Cloud Certified Professional-Cloud-Database-Engineer Exam Question
Professional-Cloud-Database-Engineer dumps & Google Cloud Certified sure practice dumps
Google Professional-Cloud-Database-Engineer exam is a certification exam offered by Google Cloud that measures an individual's ability to design, develop, and manage Google Cloud database solutions. Professional-Cloud-Database-Engineer exam is intended for individuals who have experience working with databases, data management, and application development in a cloud environment. Professional-Cloud-Database-Engineer exam tests the candidate's knowledge of Google Cloud database services, such as Cloud SQL, Cloud Spanner, and Bigtable, along with their ability to design and implement database solutions using these services.
Google Professional-Cloud-Database-Engineer Exam is a certification exam that is designed to test the skills and knowledge of professionals who are responsible for managing and administering databases on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam is part of the Google Cloud Certified program, which is a professional certification program offered by Google for individuals who want to demonstrate their expertise in Google Cloud technologies.
NEW 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. 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. - B. 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. - C. 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. - D. 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.
Answer: B
NEW QUESTION # 39
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
- A. Use Cloud SQL for MySQL
- B. Use Firestore.
- C. Use Cloud Spanner.
- D. Use Bigtable.
Answer: C
Explanation:
Spanner covers the SLA
NEW QUESTION # 40
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.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
NEW QUESTION # 41
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. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
- C. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
- D. 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.
Answer: A
Explanation:
"Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. " https://cloud.google.com/sql/docs/mysql/maintenance
NEW QUESTION # 42
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?
- A. Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
- B. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
- C. Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
- D. Replicate Cloud SQL databases across different zones.
Answer: A
NEW QUESTION # 43
Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?
- A. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
- B. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
- C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
- D. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
Answer: C
Explanation:
https://www.actifio.com/solutions/cloud/google/
NEW QUESTION # 44
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?
- A. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
- B. Create one regional Cloud SQL instance with a read replica in another region.
- C. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- D. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
Answer: A
NEW QUESTION # 45
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
- A. Run the cron job on a Compute Engine instance to continue the export.
- B. Set up Cloud Composer, and create a task to export the table daily.
- C. Use Cloud Scheduler and Cloud Functions to run the daily export.
- D. Create a streaming Datatlow job to export the table.
Answer: B
NEW QUESTION # 46
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
- A. Perform the gcloud sql operations list command.
- B. Use Cloud Audit Logs to verify the status.
- C. Use the Google Cloud Console.
- D. Check the cloudsql.googleapis.com/postgres.log instance log.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/backup-recovery/backups#troubleshooting-backups Under Troubleshooting: Issue: "You can't see the current operation's status." The Google Cloud console reports only success or failure when the operation is done. It isn't designed to show warnings or other updates. Run the gcloud sql operations list command to list all operations for the given Cloud SQL instance.
NEW QUESTION # 47
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?
- A. Take one manual backup per day, and turn off transaction log retention.
- B. Take no backups, and turn off transaction log retention.
- C. Turn on automated backup, and turn off transaction log retention.
- D. Turn on automated backup, and turn on transaction log retention.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 48
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
- A. Use Firestore.
- B. Use Cloud SQL for MySQL
- C. Use Cloud Spanner.
- D. Use Bigtable.
Answer: B
NEW QUESTION # 49
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 SQL.
- C. Use Cloud Spanner.
- D. Use Bigtable.
Answer: C
NEW QUESTION # 50
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. Create a new service account, and grant it the spanner.databases.select permission.
- 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. Reuse the existing service account that populates this database.
Answer: C
Explanation:
https://cloud.google.com/iam/docs/overview
NEW QUESTION # 51
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
- A. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- B. Enable serializable isolation in the Firebase app.
- C. Deploy a US multi-region Firestore location.
- D. Create a Firestore index on the news story date.
Answer: A
NEW QUESTION # 52
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
- A. Set up all read replicas in the same region as the primary instance with synchronous replication.
- B. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
- C. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
- D. Set up all read replicas in a different region using asynchronous replication.
Answer: C
Explanation:
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
NEW QUESTION # 53
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
- A. Use zonal Cloud SQL without high availability (HA).
- B. Use Cloud SQL with cross-region replicas.
- C. Use Cloud Spanner in a regional configuration.
- D. Use high availability (HA) Cloud SQL with multiple zones.
Answer: A
Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-
bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform
NEW QUESTION # 54
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?
- A. Use the SQL Server Always On Availability Group dashboard.
- B. Use Cloud SQL logs.
- C. Use Cloud SQL instance monitoring.
- D. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
Answer: A
Explanation:
Note, you cannot create a read replica in Cloud SQL for SQL Server unless you use an Enterprise Edition. Which is also a requirement for configuring SQL Server AG. That's not a coincidence. That's how Cloud SQL for SQL Server creates SQL Server read replicas. To find out about the replication, use the AG Dashboard in SSMS. https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#promote-replica
NEW QUESTION # 55
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
- A. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
- B. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
- C. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
- D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
Answer: C
Explanation:
Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C. https://cloud.google.com/compute/docs/disks/performance
NEW QUESTION # 56
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, perform a stale read and specify a recovery timestamp. Write the results back.
- B. If the corruption is significant, use import and export.
- C. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- 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.
Answer: C,E
Explanation:
https://cloud.google.com/spanner/docs/pitr#ways-to-recover
To recover the entire database, backup or export the database specifying a timestamp in the past and then restore or import it to a new database. This is typically used to recover from data corruption issues when you have to revert the entire database to a point-in-time before the corruption occurred.
This part describes significant corruption - A
To recover a portion of the database, perform a stale read specifying a query-condition and timestamp in the past, and then write the results back into the live database. This is typically used for surgical operations on a live database. For example, if you accidentally delete a particular row or incorrectly update a subset of data, you can recover it with this method.
This describes insignificant corruption case - E
https://cloud.google.com/spanner/docs/pitrhttps://cloud.google.com/spanner/docs/backup/restore-backup
NEW QUESTION # 57
......
Google Professional-Cloud-Database-Engineer Actual Questions and Braindumps: https://www.updatedumps.com/Google/Professional-Cloud-Database-Engineer-updated-exam-dumps.html
Pass Professional-Cloud-Database-Engineer Exam with Updated Professional-Cloud-Database-Engineer Exam Dumps PDF 2025: https://drive.google.com/open?id=18V_TRDGIV9MsgVuE7B1wM7VP5dOGi1W2