Latest Success Metrics For Actual Professional-Cloud-Database-Engineer Exam 2026 Realistic Dumps
Updated Professional-Cloud-Database-Engineer Dumps Questions For Google Exam
NEW QUESTION # 35
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. View Cloud SQL operations to view historical query information.
- C. Review application logs to identify database calls.
- D. White a Logs Explorer query to identify database queries with high execution times.
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 # 36
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. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- B. Close idle connections or restart the instance before beginning the import operation.
- C. Ensure that the service account has the Storage Admin role.
- D. Increase the amount of memory allocated to your instance.
Answer: C
NEW QUESTION # 37
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 Composer to orchestrate an export by calling the cloudsql.instances.export API.
- B. Use Cloud Composer to execute a select * from table(s) query and export results.
- C. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
- D. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
Answer: D
NEW QUESTION # 38
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
- A. Use Database Migration Service to migrate your database.
- B. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
- C. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- D. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
Answer: B
Explanation:
PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database.
+ PgBouncer is a simple PostgreSQLconnection pool that allows for several thousand connections at a time.
Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech- industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank.https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max- connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%
20bank.
NEW QUESTION # 39
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. Use Cloud SQL Auth proxy.
- B. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- C. Connect to Cloud SQL using a connection that has SSL encryption.
- D. Use customer-managed encryption keys with Cloud SQL.
Answer: C
NEW QUESTION # 40
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 two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- D. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
Answer: D
Explanation:
This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover. According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure. If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.
NEW QUESTION # 41
You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Google- recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?
- A. Manually scale down the number of nodes after the peak period has passed.
- B. Use interleaving to co-locate parent and child rows.
- C. Use granular instance sizing in Cloud Spanner and Autoscaler.
- D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
Answer: C
Explanation:
Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances,https://cloud.google.com/blog/products/databases/get-more-out-of- spanner-with-granular-instance-sizing
NEW QUESTION # 42
You are designing a solution to implement a cache to track all the products which are browsed by users on an ecommerce website, using a key-value database. Your solution needs to have the ability to connect to the database from multiple VPC networks, while having a managed service, high throughput, low latency, strong security, and private communication. What should you do-
- A. Choose Bigtable and connect using Private Google Access API endpoint(s).
- B. Choose a Memorystore for Redis instance and Private Service Access for networking connectivity.
- C. Choose a Redis instance on a VM in the Shared VPC network.
- D. Choose Memorystore for Redis Cluster and Private Service Connect for networking connectivity.
Answer: D
Explanation:
Memorystore for Redis Cluster is a fully managed, high-throughput, low-latency key-value store ideal for caching use cases. To allow connections from multiple VPC networks securely and privately, you should use Private Service Connect (PSC), which enables private communication across networks with strong security. This combination meets all requirements: managed service, high performance, strong security, and multi-VPC private connectivity.
NEW QUESTION # 43
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data.
You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?
- A. Create two separate databases in the instance, and perform dual writes from the Order Management application.
- B. Use a Cloud SQL federated query for the Sales Reporting application.
- C. Create a read replica for the Sales Reporting application.
- D. Queue up all the requested reports in PubSub, and execute the reports at night.
Answer: C
NEW QUESTION # 44
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. 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. Create secondary indexes on the 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 # 45
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
- A. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
- B. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
- C. Create a VM in Compute Engine, and run a cron job.
- D. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
Answer: D
Explanation:
Cloud Scheduler triggers actions at regular fixed intervals, whereas Cloud Tasks triggers actions based on how the individual task object is configured. Reference: https://cloud.google.com/tasks/docs/comp-tasks-sched
NEW QUESTION # 46
You have an application that performs numerous reads and writes all day running in a single Bigtable cluster. A new batch analytics job needs to read the same data and you want to make sure that the new job does not affect the existing workload. What should you do-
- A. Scale up the Bigtable instance by manually adding more nodes.
- B. Scale up the Bigtable instance by enabling Autoscaling.
- C. Add a new cluster to the existing instance, and isolate the workloads with two app profiles.
- D. Add a new cluster to the existing instance, and enable multi-cluster routing in the app profile.
Answer: C
Explanation:
This is the only way to isolate your analytical reads from the production workload-by adding a second cluster in the same Bigtable instance and creating two app profiles (one bound to the primary cluster for OLTP, and one bound to the new cluster for analytics). This keeps the batch job's heavy scans off your production nodes, while still reading the same underlying data.
NEW QUESTION # 47
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data.
What should you do?
- A. Use Identity and Access Management (IAM) for Bigtable access control.
- B. Use Google Cloud Armor to add IP addresses to an allowlist.
- C. Use VPC Service Controls to create a trusted network for the Bigtable service.
- D. Use customer-managed encryption keys (CMEK).
Answer: C
Explanation:
"Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data."
https://cloud.google.com/vpc-service-controls
NEW QUESTION # 48
Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?
- A. Use backup and restore to roll out changes to higher environments.
- B. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
- C. Use replication to roll out changes to higher environments.
- D. Use Liquibase to roll out changes to higher environments.
Answer: A
NEW QUESTION # 49
You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?
- A. Configure Firestore, and modify your application to offload queries.
- B. Configure Memorystore, and modify your application to offload queries.
- C. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
- D. Configure Bigtable, and modify your application to offload queries.
Answer: B
NEW QUESTION # 50
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. Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
- B. Use query parameters to speed up frequently executed queries.
- C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
- D. Change the Cloud Spanner configuration from multi-region to single region.
Answer: C
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 # 51
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Cloud Spanner with default encryption.
- B. Use Cloud SQL with a customer-managed encryption key (CMEK).
- C. Use Cloud Spanner with a customer-managed encryption key (CMEK).
- D. Use Bigtable with default encryption.
Answer: B
NEW QUESTION # 52
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. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- B. Close idle connections or restart the instance before beginning the import operation.
- C. Ensure that the service account has the Storage Admin role.
- D. Increase the amount of memory allocated to your instance.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
NEW QUESTION # 53
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 Compute Engine, and store backups on tapes on-premises.
- B. Migrate the Oracle databases to Bare Metal Solution for Oracle, 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 back up the Oracle databases to Cloud Storage using the Standard Storage class.
Answer: C
Explanation:
https://www.actifio.com/solutions/cloud/google/
NEW QUESTION # 54
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. Specify an authorized network with the CIDR range of the VM.
- B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
- C. Disable and remove the internal IP address assignment.
- D. Disable and remove the external IP address assignment.
Answer: D
Explanation:
It is always more secure to use an internal IP, so removing them doesn't make sense. Eliminate A. You can use Private Google Access when VM instances only have internal IP addresses, so disabling the internal IPs and use Private Google Access doesn't make sense. Eliminate B. Specifying an authorized network when they're on the same subnet doesn't make sense. Eliminate C. A way to improve network security would be to disable external IPs since they're not needed.
NEW QUESTION # 55
Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?
- A. Rerun terraform apply.
- B. Create a read replica.
- C. Use point-in-time-recovery (PITR) to recover the database.
- D. Set Terraform deletion_protection to true.
Answer: D
Explanation:
https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources
NEW QUESTION # 56
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. Specify an authorized network with the CIDR range of the VM.
- B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
- C. Disable and remove the internal IP address assignment.
- D. Disable and remove the external IP address assignment.
Answer: D
NEW QUESTION # 57
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 Cloud SQL with cross-region replicas.
- B. Use Cloud Spanner in a regional configuration.
- C. Use high availability (HA) Cloud SQL with multiple zones.
- D. Use zonal Cloud SQL without high availability (HA).
Answer: B
NEW QUESTION # 58
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. Use Query Insights to identify idle instances.
- B. Run the Recommender API to identify overprovisioned instances.
- C. Remove inactive user accounts.
- D. Build indexes on heavily accessed tables.
Answer: B
NEW QUESTION # 59
......
Full Professional-Cloud-Database-Engineer Practice Test and 220 Unique Questions, Get it Now!: https://www.validvce.com/Professional-Cloud-Database-Engineer-exam-collection.html
Best Value Available Preparation Guide for Professional-Cloud-Database-Engineer Exam: https://drive.google.com/open?id=1JHJb0QBw8w4nVzrO_tm8VmmKXc0gf6NI
