Google Certified Professional-Cloud-Database-Engineer Dumps Questions Valid Professional-Cloud-Database-Engineer Materials
Current Professional-Cloud-Database-Engineer Exam Dumps [2026] Complete Google Exam Smoothly
To earn the Google Professional-Cloud-Database-Engineer certification, candidates must pass a single exam that tests their knowledge and skills in designing, developing, and managing secure and scalable database solutions on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam consists of multiple-choice questions and is administered online.
Google Professional-Cloud-Database-Engineer certification exam is designed for professionals who want to demonstrate their expertise in designing, developing, and managing Google Cloud Platform (GCP) database solutions. Professional-Cloud-Database-Engineer exam measures the candidate's ability to design, implement, and manage highly available and scalable relational and NoSQL databases on GCP. It also tests their knowledge of various GCP database services such as Cloud SQL, Cloud Spanner, and Cloud Bigtable.
NEW QUESTION # 27
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
- A. Set up bring your own IP (BYOIP) in your VPC.
- B. Setup a static external IP address in your VPC network.
- C. Set up a Cloud NAT gateway on the Compute Engine VM.
- D. Set up Cloud NAT service.
Answer: C
NEW QUESTION # 28
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. 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.
- B. 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.
- C. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- D. Create additional read replicas, and partition your analytics users to use different read replicas.
- E. Create secondary indexes on the replica.
Answer: A,D
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 # 29
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?
- A. Use Firestore and ensure that the PersistenceEnabled option is set to true.
- B. Use Memorystore for Memcached.
- C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
- D. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
Answer: C
NEW QUESTION # 30
You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?
- A. Issue a rollback, and download your server certificate.
- B. Create a new client certificate, and download it.
- C. Create a new server certificate, and download it.
- D. Reset your SSL configuration, and download your server certificate.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/sqlserver/configure-ssl-instance#server-certs
NEW QUESTION # 31
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. 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. - B. 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. - C. 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. - D. 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.
Answer: B
NEW QUESTION # 32
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- B. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- C. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
- D. Move the physical database servers from on-premises to Google Cloud.
- E. Use a change data capture (CDC) migration strategy.
Answer: C,E
NEW QUESTION # 33
Your organization is running a critical production database on a virtual machine (VM) on Compute Engine.
The VM has an ext4-formatted persistent disk for data files. Thedatabase will soon run out of storage space.
You need to implement a solution that avoids downtime. What should you do?
- A. In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
- B. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
- C. In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
- D. In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
Answer: B
Explanation:
https://cloud.google.com/compute/docs/disks/resize-persistent-disk#resize_partitions
NEW QUESTION # 34
Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google- recommended practices to optimize platform costs. What should you do?
- A. Remove inactive user accounts.
- B. Run the Recommender API to identify overprovisioned instances.
- C. Build indexes on heavily accessed tables.
- D. Use Query Insights to identify idle instances.
Answer: B
Explanation:
The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload. It then provides recommendations on how to resize such instances and reduce cost. This page describes how this recommender works and how to use it.https://cloud.google.com/sql/docs
/mysql/recommender-sql-overprovisioned#:~:text=The%20Cloud%20SQL%20overprovisioned%20instance%
20recommender%20helps%20you%20detect%20instances%20that%20are%20unnecessarily%20large%
20for%20a%20given%20workload.%20It%20then%20provides%20recommendations%20on%20how%20to%
20resize%20such%20instances%20and%20reduce%20cost.%20This%20page%20describes%20how%
20this%20recommender%20works%20and%20how%20to%20use%20it.
NEW QUESTION # 35
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. Shard data required by the application into multiple instances.
- B. Decrease the number of processing units.
- C. Modify the database schema, and add additional indexes.
- D. Increase the number of processing units.
Answer: D
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 # 36
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 the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- C. Use Cloud SQL logs.
- D. Use Cloud SQL instance monitoring.
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 # 37
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.viewer and roles/spanner.databaseUser
- B. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- C. roles/cloudsql.client and roles/spanner.databaseReader
- D. roles/cloudsql.editor and roles/spanner.admin
Answer: A
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 # 38
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?
- A. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- B. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
- C. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
Answer: C
NEW QUESTION # 39
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?
- A. Migrate applications to Cloud SQL.
- B. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- C. Migrate applications and Oracle databases to Compute Engine.
- D. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
Answer: D
NEW QUESTION # 40
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 Compute Engine.
- B. Migrate the Oracle databases to Cloud Spanner.
- C. Migrate the Oracle databases to Bare Metal Solution for Oracle.
- D. Migrate the Oracle databases to Cloud SQL.
Answer: C
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 # 41
Your company's mission-critical, globally available application is supported by a Cloud Spanner database.
Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?
- A. roles/spanner.backupWriter
- B. roles/spanner.databaseReader
- C. roles/spanner.databaseUser
- D. roles/spanner.viewer
Answer: B
Explanation:
https://cloud.google.com/spanner/docs/iam?hl=it
NEW QUESTION # 42
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?
- A. Disable and remove the external IP address assignment.
- B. Disable and remove the internal IP address assignment.
- C. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
- D. Specify an authorized network with the CIDR range of the VM.
Answer: C
NEW QUESTION # 43
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. Use workload identity federation to impersonate a service account.
- B. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
- C. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- D. Ask existing users to set their Google password to match their corporate password.
Answer: A
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 # 44
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 Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- B. Use Cloud Spanner with a custom autoscaling solution.
- C. Use a Biglable cluster with autoscaling.
- D. Use sharded Cloud SQL instances with one or more stores per database instance.
Answer: B
Explanation:
https://cloud.google.com/spanner/docs/autoscaling-overview
1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit 2. Scale is done manually on SQL Cloud
NEW QUESTION # 45
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?
- A. Automate instance creation by writing a Dataflow job.
- B. Automate instance creation by setting up Terraform scripts.
- C. Create clones from a template Cloud SQL instance.
- D. Create the instances using the Google Cloud Console UI.
Answer: B
NEW QUESTION # 46
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
- A. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
- B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- C. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
- D. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#serverless
NEW QUESTION # 47
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?
- A. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C - D. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C
Answer: A
NEW QUESTION # 48
You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?
- A. Connect by using AlloyDB Auth Proxy installed in the GKE cluster.
- B. Connect by using the private IP address of the AlloyDB cluster directly from the application.
- C. Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.
- D. Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.
Answer: B
NEW QUESTION # 49
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?
- A. Use many smaller Cloud SQL instances.
- B. Increase the number of CPUs for your instance.
- C. Increase the storage size for the instance.
- D. Use Cloud Spanner instead of Cloud SQL.
Answer: D
NEW QUESTION # 50
......
Professional-Cloud-Database-Engineer Premium PDF & Test Engine Files with 144 Questions & Answers: https://www.actual4labs.com/Google/Professional-Cloud-Database-Engineer-actual-exam-dumps.html
Get 100% Real Professional-Cloud-Database-Engineer Accurate & Verified Answers As Seen in the Real Exam!: https://drive.google.com/open?id=1HUkJEalbQMcyO1Ebh8nGajf09q0TXxny