Nov-2025 Google Professional-Cloud-Database-Engineer Actual Questions and Braindumps
Professional-Cloud-Database-Engineer Dumps To Pass Google Exam in 24 Hours - PracticeDump
The Google Professional-Cloud-Database-Engineer exam consists of multiple-choice and multiple-select questions that are designed to test the candidate's knowledge of various database technologies and their ability to apply that knowledge to real-world scenarios. Professional-Cloud-Database-Engineer exam covers topics such as database design, data modeling, database migration, replication, backup and recovery, performance optimization, and security. Candidates are expected to have a deep understanding of SQL and should be familiar with various database management systems such as MySQL, PostgreSQL, and Oracle.
NEW QUESTION # 85
Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?
- A. Issue a gcloud compute instances update command to increase the number of vCPUs.
- B. Update a MySQL database flag to increase the number of vCPUs.
- C. Issue a gcloud sql instances patch command to increase the number of vCPUs.
- D. Back up the database, create an instance with additional vCPUs, and restore the database.
Answer: C
NEW QUESTION # 86
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 Bigtable with clusters in multiple regions to deploy the database
- B. Use Cloud Spanner to deploy the database.
- C. Use BigQuery to deploy the database
- D. Use Cloud SQL with a regional read replica 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 # 87
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?
- A. Set up Serverless VPC Access.
- B. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- C. Set up Private Service Connect.
- D. Set up Traffic Director.
Answer: B
Explanation:
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.
NEW QUESTION # 88
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
- B. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
- C. Use Cloud Composer to execute a select * from table(s) query and export results.
- D. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
Answer: A
NEW QUESTION # 89
Your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability (HA). You need to configure a scalable database solution to support anticipated rapid growth and optimal application performance. What should you do?
- A. Create an AlloyDB instance in HA mode with a cross-region read replica.
- B. Implement Bigtable with replication across multiple regions and configure to prioritize data accuracy.
- C. Create a spanner instance across regions for optimal performance.
- D. Create a Cloud SQL instance in HA mode with a cross-region read replica.
Answer: C
NEW QUESTION # 90
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. Modify the database schema, and add additional indexes.
- B. Shard data required by the application into multiple instances.
- C. Decrease the number of processing units.
- 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 # 91
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
- A. Migrate to Cloud SQL for PostgreSQL.
- B. Migrate to Cloud SQL for SQL Server.
- C. Migrate to Google Kubernetes Engine (GKE).
- D. Migrate to Compute Engine.
Answer: A
NEW QUESTION # 92
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.editor and roles/spanner.admin
- B. roles/cloudsql.viewer and roles/spanner.databaseUser
- C. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- D. roles/cloudsql.client and roles/spanner.databaseReader
Answer: D
NEW QUESTION # 93
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
- A. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
- B. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
- C. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
- D. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
Answer: A
Explanation:
Binary Logging enabled, with that you can identify the point of time the data was good and recover from that point time. https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform_the_point-in-time_recovery_using_binary_log_positions
NEW QUESTION # 94
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. Use the Query Insights dashboard to identify high execution times.
- B. Review application logs to identify database calls.
- C. White a Logs Explorer query to identify database queries with high execution times.
- D. View Cloud SQL operations to view historical query information.
Answer: A
NEW QUESTION # 95
You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?
- A. Deploy the database using Cloud SQL.
- B. C.Deploy the database using Bigtable.
- C. Use BigQuery, and load data in batches.
- D. Deploy the database using Cloud Spanner.
Answer: B
Explanation:
Bigtable is a scalable, fully managed, and high-performance NoSQL database service that can handle semi-structured data and support real-time monitoring and analysis. Cloud SQL is a relational database service that does not support semi-structured dat a. BigQuery is a data warehouse service that is optimized for batch processing and analytics, not real-time monitoring. Cloud Spanner is a relational database service that supports semi-structured data with JSON data type, but it is more expensive and complex than Bigtable for this use case.
NEW QUESTION # 96
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?
- A. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
- B. Use gcloud sql instances failover <ReplicaInstanceName>.
- C. Use gcloud sql instances failover <PrimaryInstanceName>.
- D. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
Answer: A
NEW QUESTION # 97
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. Use the Query Insights dashboard to identify high execution times.
- B. Review application logs to identify database calls.
- C. White a Logs Explorer query to identify database queries with high execution times.
- D. View Cloud SQL operations to view historical query information.
Answer: A
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 # 98
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?
- A. 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. - B. 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. - C. 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. - D. 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.
Answer: B
NEW QUESTION # 99
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 database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- B. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- C. Determine whether the versions of Cloud SQL 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: D
Explanation:
Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria
NEW QUESTION # 100
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
- A. Write a utility to scan application logs.
- B. Write a utility to scan database query logs.
- C. Shut down and restart each application.
- D. Use query tags to add application-centric database monitoring.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags
NEW QUESTION # 101
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
- A. Connect to Cloud SQL using a connection that has SSL encryption.
- B. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- C. Use Cloud SQL Auth proxy.
- D. Use customer-managed encryption keys with Cloud SQL.
Answer: A
NEW QUESTION # 102
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 internal IP address assignment.
- B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
- C. Specify an authorized network with the CIDR range of the VM.
- D. Disable and remove the external IP address assignment.
Answer: B
NEW QUESTION # 103
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?
- A. Use Memorystore for Redis with multi-zones within a region.
- B. Use Cloud SQL for PostgreSQL with cross-region replicas.
- C. Use Cloud Spanner with multi-region configuration.
- D. Use Bigtable with multi-region clusters.
Answer: B
NEW QUESTION # 104
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do?
(Choose two.)
- A. Drop or disable all users except database administration users.
- B. Shut down the database before the Data Migration Service task is started.
- C. Ensure that pglogical is installed on the source PostgreSQL database.
- D. Disable all foreign key constraints on the source PostgreSQL database.
- E. Ensure that all PostgreSQL tables have a primary key.
Answer: C,E
Explanation:
https://cloud.google.com/database-migration/docs/postgres/faq
NEW QUESTION # 105
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?
- A. Set up Serverless VPC Access.
- B. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- C. Set up Private Service Connect.
- D. Set up Traffic Director.
Answer: B
Explanation:
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%
20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.
&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.
NEW QUESTION # 106
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?
- A. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
- B. Set up different organizations for each database type, and apply policy constraints at the organization level.
- C. 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.
- D. 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.
Answer: A
NEW QUESTION # 107
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.databaseUser for Person B
roles/spanner databaseReader for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C - D. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C
Answer: B
Explanation:
https://cloud.google.com/spanner/docs/iam#spanner.backupWriter
NEW QUESTION # 108
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted.
The test has concluded and you want to return to the pre-test configuration. What should you do?
- A. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
- B. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
- C. Bring DB-1 back online.
- D. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
Answer: D
Explanation:
If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover.https://cloud.google.com/sql/docs
/mysql/high-availability#failback
NEW QUESTION # 109
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use Cloud SQL for MySQL external replica.
- B. Use Data Migration Service.
- C. Use the mysqldump utility and binary logs.
- D. Use external server replication.
Answer: A
Explanation:
An external replica is a method that allows you to create a read-only copy of your Cloud SQL instance on an external server, such as a Compute Engine instance or an on-premises database server1. An external replica can help you scale reads and offload management operations from your data center to Google Cloud. You can also use an external replica for disaster recovery, migration, or reporting purposes1.
To create an external replica, you need to configure a Cloud SQL instance that replicates to one or more replicas external to Cloud SQL, and a source representation instance that represents the source database server in Cloud SQL1. You also need to enable access on the Cloud SQL instance for the IP address of the external replica, create a replication user, and export and import the data from the source database server to the external replica1.
NEW QUESTION # 110
......
Download the Latest Professional-Cloud-Database-Engineer Dump - 2025 Professional-Cloud-Database-Engineer Exam Question Bank: https://www.practicedump.com/Professional-Cloud-Database-Engineer_actualtests.html
Buy Latest Professional-Cloud-Database-Engineer Exam Q&A PDF - One Year Free Update: https://drive.google.com/open?id=1VufGrq5GE9ECpVPxGiiXXuYbknHibt6x