[Aug 29, 2026] Fully Updated Google Cloud Certified (Professional-Cloud-Database-Engineer) Certification Sample Questions
Latest Google Professional-Cloud-Database-Engineer Real Exam Dumps PDF
The Google Professional-Cloud-Database-Engineer exam tests candidates' knowledge in various areas, including database design, data modeling, database security, and database migration. Candidates are also expected to have a deep understanding of the different Google Cloud database services, such as Cloud SQL, Cloud Spanner, and Cloud Bigtable. Professional-Cloud-Database-Engineer exam assesses candidates' ability to design and implement highly available, scalable, and secure database solutions using Google Cloud.
NEW QUESTION # 104
Which approach delivers real time alerts for Cloud Spanner transaction failures and also reflects overall application health?
- A. Error Reporting notifications
- B. Cloud Monitoring alerts on Spanner transaction failure metrics
- C. Cloud Logging logs based metric with alerting
Answer: B
Explanation:
This approach uses the native metrics that Cloud Spanner exports to Monitoring which include error and abort signals as well as latency and throughput. You can create alerting policies that evaluate these metrics at short intervals so you get near real time notifications when transaction failures exceed a threshold. You can also build dashboards and service level objectives in the same place which provides a consolidated view of overall application health.
NEW QUESTION # 105
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.backupWriter for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C - D. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C
Answer: B
NEW QUESTION # 106
Your company's rapidly growing ecommerce application uses Cloud SQL for MySQL.
Performance issues are surfacing during peak traffic periods. You need to ensure that the database can handle the load while minimizing downtime. What should you do-
- A. Migrate to a Cloud SQL for PostgreSQL database for better performance during high load.
- B. Use read replicas for query offloading, configure automatic failover, and test failover procedures regularly.
- C. Increase storage size on the existing instance and implement client-side caching for frequently accessed data.
- D. Vertically scale the primary instance by significantly increasing compute resources, such as vCPUs and memory.
Answer: B
Explanation:
By deploying one or more read replicas, you can offload read-heavy queries from the primary and keep it focused on writes, smoothing out load spikes without interrupting service. Enabling automatic failover and regularly testing it ensures that if the primary does fail or needs maintenance, your application continues running with minimal downtime.
NEW QUESTION # 107
When comparing Google Cloud managed NoSQL services, which cost component should you consistently emphasize for a precise TCO analysis?
- A. Storage capacity costs
- B. Query execution and index upkeep costs
- C. CMEK for data at rest
Answer: B
Explanation:
Workload driven charges such as query execution and index upkeep are the most variable across services and are tightly coupled to how your application actually uses the database. In Firestore every document write can update multiple indexes which increases index upkeep costs and every read or query incurs operation charges that fall under query execution. In Bigtable you provision for throughput which still maps to demand from query execution. Centering comparisons on query execution and index upkeep costs produces a more accurate and comparable total cost of ownership across architectures.
NEW QUESTION # 108
Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?
- A. Bigtable
- B. Cloud SQL
- C. Cloud Spanner
- D. BigQuery
Answer: D
Explanation:
https://cloud.google.com/products/databases
NEW QUESTION # 109
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. Increase the number of processing units.
- C. Decrease the number of processing units.
- D. Modify the database schema, and add additional indexes.
Answer: B
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 # 110
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.client and roles/spanner.databaseReader
- B. roles/cloudsql.viewer and roles/spanner.databaseUser
- C. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- D. roles/cloudsql.editor and roles/spanner.admin
Answer: B
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 # 111
Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?
- A. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket. - B. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage. - C. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Keep backups older than one day stored in Actifio OnVault storage. - D. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
Answer: B
NEW QUESTION # 112
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 5 AM, and deny maintenance periods between November 1 and February 15.
- B. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
- C. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
- D. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
Answer: C
Explanation:
"Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. " https://cloud.google.com/sql/docs/mysql/maintenance
NEW QUESTION # 113
You are planning to migrate a 10 TB relational database from an on-premises environment to 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 two.)
- A. Use an external IP address for the Cloud SQL instance, and configure firewall rules.
- B. Set up Identity and Access Management (IAM) roles to restrict access with Cloud SQL with an internal IP address.
- C. Establish a Private Service Connect connection between your on-premises environment and the Cloud SQL instance.
- D. Configure Cloud SQL for automatic patching, and enable binary logging.
- E. Leverage Storage Transfer Service with client-side encryption.
Answer: B,C
Explanation:
Establish a Private Service Connect connection between your on-premises environment and the Cloud SQL instance.
Private Service-Connect gives you a Google-managed, internal-only endpoint for Cloud-SQL, so your migration traffic never traverses the public Internet while still using TLS in-flight encryption.
Set up Identity and Access Management (IAM) roles to restrict access with Cloud SQL on an internal IP address.
Lock your Cloud-SQL to private-IP only, then grant only the minimal Cloud-SQL IAM roles (e.g.
roles/cloudsql.client) to your migration service accounts and users. This ensures only authorized principals from your VPC can connect.
NEW QUESTION # 114
Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?
- A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- B. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
- C. Create a read replica of the instance with SSDs, and perform a failover to the new instance
- D. Edit the instance to change the storage type from HDD to SSD.
Answer: B
NEW QUESTION # 115
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. Set Terraform deletion_protection to true.
- B. Rerun terraform apply.
- C. Create a read replica.
- D. Use point-in-time-recovery (PITR) to recover the database.
Answer: A
Explanation:
https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources
NEW QUESTION # 116
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 replication to roll out changes to higher environments.
- B. Use Liquibase to roll out changes to higher environments.
- C. Use backup and restore to roll out changes to higher environments.
- D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
Answer: B
Explanation:
https://cloud.google.com/spanner/docs/use-liquibase
NEW QUESTION # 117
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?
- A. Create another schema to load older data.
- B. Manually or automatically increase the storage capacity.
- C. Normalize the database to the third normal form.
- D. Compress the data using a different compression algorithm.
Answer: D
NEW QUESTION # 118
You are migrating your 10 TB on-premises PostgreSQL database to Cloud SQL for PostgreSQL by using Database Migration Service. During the migration, there will be schema changes in the source database. You need to ensure any schema changes are replicated, while keeping disruption to the ongoing migration to a minimum.
What should you do?
- A. Make the schema changes in both source and destination after stopping writes in source.
- B. Make the schema changes in the source by using the pglogical.replicate_ddl_command PostgreSQL extension.
- C. Make the schema changes in the destination by using the
pglogical.replicate_ddl_commandPostgreSQL extension. - D. Stop the Database Migration Service migration job. Make the schema changes in the source.Restart the Database Migration Service migration job.
Answer: B
Explanation:
To keep disruption minimal while ensuring schema changes are replicated during an ongoing Database Migration Service (DMS) continuous migration for PostgreSQL, you should apply schema changes on the source using the pglogical.replicate_ddl_command extension so the DDL is propagated through logical replication to the destination automatically.
NEW QUESTION # 119
You are the DBA working at a large bank in Europe. Your business-critical banking application runs on Oracle 12.2 in your on-premises data center. You decided to modernize your on- premises Oracle database by migrating to AlloyDB. You must meet the following requirements:
- Remain on-premises and maintain open-source portability.
- Meet regulatory requirements for data residency.
- Support both OLTP and OLAP workloads.
- Maintain high availability (HA) mode and automatic failover.
What should you do-
- A. Migrate to AlloyDB for PostgreSQL by using Database Migration Service.
- B. Deploy AlloyDB Omni in a standalone VM on-premises, and set up disaster recovery (DR) in AlloyDB for PostgreSQL.
- C. Deploy AlloyDB Omni as a docker-based container in your on-premises VM, enable HA for it, and migrate your Oracle database to the Omni container.
- D. Deploy Kubernetes-based AlloyDB Omni database cluster on-premises. Enable HA by using the AlloyDB Omni Kubernetes operator, and migrate your Oracle database to Omni.
Answer: D
Explanation:
On-premises: AlloyDB Omni is designed for on-prem deployments and meets your data residency requirements.
HA and Failover: Only the Kubernetes-based AlloyDB Omni deployment with the AlloyDB Omni Kubernetes Operator supports high availability with automatic failover.
Open-source portability: AlloyDB Omni is PostgreSQL-compatible, ensuring future flexibility.
OLTP + OLAP: AlloyDB supports both transactional and analytical workloads using its vectorized execution and columnar engine features.
Regulatory requirements: Staying on-premises aligns with strict data residency and compliance needs common in EU banking environments.
NEW QUESTION # 120
Your company is developing a new global transactional application that must be ACID-compliant and have
99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
- A. Use Cloud Spanner.
- B. Use Cloud SQL.
- C. Use Firestore.
- D. Use Bigtable.
Answer: A
NEW QUESTION # 121
Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?
- A. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
- B. Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
- C. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
- D. Use Memorystore to handle your low-latency requirements and for real-time analytics.
Answer: A
Explanation:
Start with the lowest tier and smallest size and then grow your instance as needed. Memorystore provides automated scaling using APIs, and optimized node placement across zones for redundancy. Memorystore for Memcached can support clusters as large as 5 TB, enabling millions of QPS at very low latency
NEW QUESTION # 122
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. 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. - B. 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. - C. 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. - D. 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.
Answer: C
NEW QUESTION # 123
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?
- A. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
- B. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
- C. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- D. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
Answer: C
Explanation:
Use Firestore in Datastore mode for new server projects. Firestore in Datastore mode allows you to use established Datastore server architectures while removing fundamental Datastore limitations. Datastore mode can automatically scale to millions of writes per second. Use Firestore in Native mode for new mobile and web apps. Firestore offers mobile and web client libraries with real-time and offline features. Native mode can automatically scale to millions of concurrent clients.
NEW QUESTION # 124
You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?
- A. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Connect to the instance using a connection pool to best manage connections to the instance. - B. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Use Cloud SQL Auth proxy to connect to the instance. - C. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Use Cloud SQL Auth proxy to connect to the instance. - D. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Connect to the instance using a connection pool to best manage connections to the instance.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-run#configure https://cloud.google.com/sql/docs/mysql/connect-run#connection-pools
NEW QUESTION # 125
......
Google Professional-Cloud-Database-Engineer Dumps - Secret To Pass in First Attempt: https://examsforall.lead2passexam.com/Google/valid-Professional-Cloud-Database-Engineer-exam-dumps.html