Verified Professional-Cloud-Database-Engineer dumps Q&As - Pass Guarantee Exam Dumps Test Engine [2026]
Professional-Cloud-Database-Engineer dumps and 144 unique questions
NEW QUESTION # 75
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. Create a Firestore index on the news story date.
- B. Deploy a US multi-region Firestore location.
- C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- D. Enable serializable isolation in the Firebase app.
Answer: C
Explanation:
A global audience strongly suggests serving content via Google's Content Delivery Network. Changing the isolation level won't decrease cost or latency
NEW QUESTION # 76
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
- A. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- B. Ask existing users to set their Google password to match their corporate password.
- C. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
- D. Use workload identity federation to impersonate a service account.
Answer: D
Explanation:
Updating passwords represents user disruption. Eliminate B. Eliminate C for the same reason. D doesn't make sense, leaves A. From Google's documentation, "Traditionally, applications running outside Google Cloud can use service account keys to access Google Cloud resources. However, service account keys are powerful credentials, and can present a security risk if they are not managed correctly. With identity federation, you can use Identity and Access Management (IAM) to grant external identities IAM roles, including the ability to impersonate service accounts. This approach eliminates the maintenance and security burden associated with service account keys." https://cloud.google.com/iam/docs/workload-identity-federation
NEW QUESTION # 77
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
- A. Use Database Migration Service to replicate tables into BigQuery.
- B. Develop a custom data replication service to send data into BigQuery.
- C. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
- D. Use Cloud SQL federated queries.
Answer: C
NEW QUESTION # 78
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
- A. Use Cloud SQL with a regional read replica to deploy the database.
- B. Use Cloud Spanner to deploy the database.
- C. Use Bigtable with clusters in multiple regions to deploy the database
- D. Use BigQuery to deploy the database
Answer: B
Explanation:
Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, automatic, synchronous replication for high availability, and support for two SQL dialects: Google Standard SQL (ANSI 2011 with extensions) and PostgreSQL.
NEW QUESTION # 79
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow.You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)
- A. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- B. Create secondary indexes on the replica.
- C. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
- D. Create additional read replicas, and partition your analytics users to use different read replicas.
- E. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re- enable replication and optimize performance by setting flags on the primary instance.
Answer: D,E
Explanation:
Replication lag and slow report performance. E is eliminated because using BigQuery would mean changes to the current reports. Report slowness could be the result of poor indexing or just too much read load (or both!).
Since excessive load is mentioned in the question, creating additional read replicas and spreading the analytics workload around makes B correct and eliminates A as a way to speed up reporting. That leaves the replication problem. Cloud SQL enables single threaded replication by default, so it stands to reason enabling parallel replication would help the lag. To do that you disable replication on the replica (not the primary), set flags on the replica and optionally set flags on the primary instance to optimize performance for parallel replication.
That makes C correct and D incorrect.https://cloud.google.com/sql/docs/mysql/replication/manage- replicas#configuring-parallel-replication
NEW QUESTION # 80
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?
- A. Use sharded Cloud SQL instances with one or more stores per database instance.
- B. Use a Biglable cluster with autoscaling.
- C. Use Cloud Spanner with a custom autoscaling solution.
- D. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION # 81
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?
- A. Increase the number of processing units.
- B. Modify the database schema, and add additional indexes.
- C. Decrease the number of processing units.
- D. Shard data required by the application into multiple instances.
Answer: A
Explanation:
In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%20the%20CPU%20utilization%20of%20the%20instance%20is%20above%20the%20recommended%20level%2C%20you%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%20auto%20scaling. "Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling." Indexes and schema are reviewed post identifying query with slow performance. Refer : https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#review-schema
NEW QUESTION # 82
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. Turn on automated backup, and turn off transaction log retention.
- C. Turn on automated backup, and turn on transaction log retention.
- D. Take no backups, and turn off transaction log retention.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 83
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?
- A. Migrate the Oracle databases to Cloud SQL.
- B. Migrate the Oracle databases to Cloud Spanner.
- C. Migrate the Oracle databases to Compute Engine.
- D. Migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: D
Explanation:
This answer is correct because Bare Metal Solution for Oracle is a service that provides dedicated physical servers and networking infrastructure for running Oracle databases on Google Cloud1. Bare Metal Solution for Oracle supports Oracle RAC, which is a cluster database that provides high availability, scalability, and performance for Oracle workloads2. By using Bare Metal Solution for Oracle, you can migrate your Oracle databases with minimal to no changes to the applications, and you can leverage the native Google Cloud services and interconnectivity1.
NEW QUESTION # 84
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 insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- B. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- C. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
- D. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- E. If the corruption is significant, use import and export.
Answer: A,B
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/pitr https://cloud.google.com/spanner/docs/backup/restore-backup
NEW QUESTION # 85
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?
- A. Change the Cloud Spanner configuration from multi-region to single region.
- B. Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
- C. Use query parameters to speed up frequently executed queries.
- D. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
Answer: D
Explanation:
To troubleshoot high read latency, you can use SQL statements to analyze the SPANNER_SYS.READ_STATS* tables. These tables contain statistics about read operations in Cloud Spanner, including the number of reads, read latency, and the number of read errors. By analyzing these tables, you can identify the cause of the high read latency and take appropriate action to resolve the issue. Other options, such as using query parameters to speed up frequently executed queries or changing the Cloud Spanner configuration from multi-region to single region, may not be directly related to the issue of high read latency. Similarly, analyzing the SPANNER_SYS.QUERY_STATS* tables, which contain statistics about query operations, may not be relevant to the issue of high read latency.
NEW QUESTION # 86
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. 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.
- C. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
- D. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
Answer: C
NEW QUESTION # 87
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?
- A. View Cloud SQL operations to view historical query information.
- B. Review application logs to identify database calls.
- C. Use the Query Insights dashboard to identify high execution times.
- D. White a Logs Explorer query to identify database queries with high execution times.
Answer: C
Explanation:
A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone's persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.
NEW QUESTION # 88
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 multi-cluster routing.
- B. Use the default app profile with single-cluster routing.
- C. Create a custom app profile with multi-cluster routing.
- D. Create a custom app profile with single-cluster routing.
Answer: B
NEW QUESTION # 89
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?
- A. Use Bigtable with Looker.
- B. Use Cloud Spanner with Data Studio.
- C. Use MongoD8 Atlas with Charts.
- D. Use Firestore with Looker.
Answer: C
Explanation:
This scenario has BigTable written all over it - large amounts of data from many devices to be analysed in realtime. I would even argue it could qualify as a multicloud solution, given the links to HBASE. BUT it does not support SQL queries and is not therefore compatible (on its own) with Looker. Firestore + Looker has the same problem. Spanner + Data Studio is at least a compatible pairing, but I agree with others that it doesn't fit this use-case - not least because it's Google-native. By contrast, MongoDB Atlas is a managed solution (just not by Google) which is compatible with the proposed reporting tool (Mongo's own Charts), it's specifically designed for this type of solution and of course it can run on any cloud.
NEW QUESTION # 90
You are planning to migrate a 10TB relational database from an on-premises environment la Cloud SQL for PostgreSQL. The database contains sensitive customer Information. You want to follow Google-recommended practices to keep data secure during the migration.
What should you do?
Choose 2 answers
- A. Use an external IH address for the Cloud SQL Instance, and configure firewall rules.
- B. Set up identity Access Management JIAM) roles to restrict access with Cloud SQL with an internal IP address.
- C. Configure Cloud SQL for automatic patching, and enable binary logging.
- D. Establish a Private Se-vice Connect connection between your on-premises environment and the Cloud SQL instance
- E. Leverage Storage Transfer Service with client side encryption.
Answer: B,D
NEW QUESTION # 91
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.
What should you do? (Choose two.)
- A. Use a cross-region read replica to migrate the databases to Cloud SQL.
- B. Use replication from an external server to migrate the databases to Cloud SQL.
- C. Use an external read replica to migrate the databases to Cloud SQL.
- D. Use a read replica to migrate the databases to Cloud SQL.
- E. Use Database Migration Service to migrate the databases to Cloud SQL.
Answer: B,E
NEW QUESTION # 92
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 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. - D. 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.
Answer: D
Explanation:
https://cloud.google.com/datastream/docs/overview.
NEW QUESTION # 93
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 insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- B. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- C. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
- D. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- E. If the corruption is significant, use import and export.
Answer: A,B
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 # 94
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
- A. Use Bigtable for data storage.
- B. Use Memorystore for data storage.
- C. Use Cloud SQL for data storage.
- D. Use Cloud Spanner for data storage.
Answer: C
NEW QUESTION # 95
Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)
- A. Create a PostgreSQL database on-premises as the HA option.
- B. Schedule automated backups.
- C. Set up manual backups.
- D. Enable point-in-time recovery.
- E. Configure single zone availability for automated backups.
Answer: A,D
NEW QUESTION # 96
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?
- A. Increase the number of processing units.
- B. Modify the database schema, and add additional indexes.
- C. Decrease the number of processing units.
- D. Shard data required by the application into multiple instances.
Answer: A
NEW QUESTION # 97
An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?
- A. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- B. roles/cloudsql.client and roles/spanner.databaseReader
- C. roles/cloudsql.viewer and roles/spanner.databaseUser
- D. roles/cloudsql.editor and roles/spanner.admin
Answer: C
Explanation:
To read data out of Cloud SQL for SQL Server, you need to use a service account with the roles/cloudsql.viewer role on the Cloud SQL instance. This role grants the service account permission to read data from the instance. Whereas roles/cloudsql.instanceUser will only allow to login to cloud SQL instance. No resource will be allowed to view.
NEW QUESTION # 98
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?
- A. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance. - B. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - C. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - D. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
Answer: A
NEW QUESTION # 99
......
Google Professional-Cloud-Database-Engineer certification exam is a valuable credential for IT professionals who want to demonstrate their expertise in managing databases on the Google Cloud Platform. By earning this certification, you can validate your practical skills and knowledge in designing, developing, and administering scalable and secure databases on Google Cloud. Google Cloud Certified - Professional Cloud Database Engineer certification can help you enhance your job prospects, increase your earning potential, and gain recognition as a proficient database professional.
To become a Google Cloud Certified Professional-Cloud-Database-Engineer, candidates must pass a two-hour computer-based exam that consists of multiple-choice and multiple-response questions. Professional-Cloud-Database-Engineer exam is designed to test a candidate's ability to design, develop, and manage cloud-based databases on Google Cloud Platform. Candidates must have a strong understanding of database management, database security, and database performance tuning.
Professional-Cloud-Database-Engineer Dumps for Pass Guaranteed - Pass Professional-Cloud-Database-Engineer Exam: https://quizguide.actualcollection.com/Professional-Cloud-Database-Engineer-exam-questions.html