Real Professional-Cloud-Database-Engineer Exam Questions are the Best Preparation Material

Practice on 2025 LATEST Professional-Cloud-Database-Engineer Exam Updated 144 Questions

Google Professional-Cloud-Database-Engineer certification exam is a challenging and in-depth exam that requires a deep understanding of foundational database concepts, as well as advanced knowledge of Google Cloud Platform's database services. Candidates who successfully complete the Google Cloud Certified - Professional Cloud Database Engineer exam demonstrate their expertise in designing, implementing, and managing databases on the Google Cloud Platform.

Google Professional-Cloud-Database-Engineer certification exam consists of multiple-choice and multiple-select questions that assess a candidate's knowledge and skills in database design, data modeling, database migration, database administration, and database optimization. Professional-Cloud-Database-Engineer exam evaluates a candidate's ability to design, implement, and manage highly available, scalable, and secure database solutions on Google Cloud Platform.

 

NEW QUESTION # 62
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. Create a read replica.
• B. Use point-in-time-recovery (PITR) to recover the database.
• C. Rerun terraform apply.
• D. Set Terraform deletion_protection to true.

Answer: D

Explanation:
. From Google's documentation, "For stateful resources, such as databases, ensure that deletion protection is enabled. The syntax is: lifecycle { prevent_destroy = true } https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources

NEW QUESTION # 63
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

• A. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
• B. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
• C. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
• D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

Answer: A

NEW QUESTION # 64
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

• A. Create a clone database from a read replica database, and restore the clone into a different zone.
• B. Create a clone database from a read replica database, and restore the clone in the same region.
• C. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
• D. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.

Answer: D

Explanation:
Using import/export from last week is slow for large scale databases and will restore database from last week.

NEW QUESTION # 65
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. Setup a static external IP address in your VPC network.
• B. Set up bring your own IP (BYOIP) in your VPC.
• C. Set up Cloud NAT service.
• D. Set up a Cloud NAT gateway on the Compute Engine VM.

Answer: D

NEW QUESTION # 66
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

• A. Reuse the existing service account that populates this database.
• B. Create a new service account, and grant it the Cloud Spanner Database Admin role.
• C. Create a new service account, and grant it the Cloud Spanner Database Reader role.
• D. Create a new service account, and grant it the spanner.databases.select permission.

Answer: B

NEW QUESTION # 67
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. Ensure that all PostgreSQL tables have a primary key.
• B. Shut down the database before the Data Migration Service task is started.
• C. Drop or disable all users except database administration users.
• D. Disable all foreign key constraints on the source PostgreSQL database.
• E. Ensure that pglogical is installed on the source PostgreSQL database.

Answer: A,E

Explanation:
https://cloud.google.com/database-migration/docs/postgres/faq

NEW QUESTION # 68
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. Create additional read replicas, and partition your analytics users to use different read replicas.
• 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. 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.
• 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 # 69
Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?

• A. Watch Query Insights for long running queries.
• B. Watch the Cloud SQL instance monitor for CPU utilization metrics.
• C. Watch the Cloud SQL recommenders for overprovisioned instances.
• D. Watch Cloud Trace for application requests that are failing.

Answer: A

NEW QUESTION # 70
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7.
You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

• A. Use Cloud SQL serverless exports.
• B. Use the mysqldump utility on the primary database instance to export the backup.
• C. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
• D. Create a read replica, and then use the mysqldump utility to export each table.

Answer: A

Explanation:
https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports

NEW QUESTION # 71
Your company is developing a 24/7. global, real-lime analytics platform that needs to store and process large amounts of versioned time-series data. You need to design a platform that Is highly scalable to accommodate traffic spikes and ensure high availability for mission-critical operations. What should you do?

• A. Implement a multi-cluster Billable instance across multiple regions with replication.
• B. Implement a multi-cluster Bigtable Instance with autoscaling enabled and optimal schema design.
• C. Implement a single-cluster Bigtable Instance with autoscaling enabled and row key design
• D. implement AlloyDB for PostgreSQL to handle the analytical workload using read replica

Answer: A

NEW QUESTION # 72
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 SQL.
• C. Migrate the Oracle databases to Bare Metal Solution for Oracle.
• D. Migrate the Oracle databases to Cloud Spanner.

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 # 73
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 Bigtable.
• B. Use Cloud Spanner.
• C. Use Cloud SQL.
• D. Use Firestore.

Answer: C

NEW QUESTION # 74
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. Ensure that all PostgreSQL tables have a primary key.
• B. Shut down the database before the Data Migration Service task is started.
• C. Drop or disable all users except database administration users.
• D. Disable all foreign key constraints on the source PostgreSQL database.
• E. Ensure that pglogical is installed on the source PostgreSQL database.

Answer: A,E

Explanation:
https://cloud.google.com/database-migration/docs/postgres/faq

NEW QUESTION # 75
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 Google Kubernetes Engine (GKE).
• B. Migrate to Compute Engine.
• C. Migrate to Cloud SQL for PostgreSQL.
• D. Migrate to Cloud SQL for SQL Server.

Answer: B

Explanation:
https://cloud.google.com/sql/docs/sqlserver/features

NEW QUESTION # 76
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency.
What should you do?

• A. Use direct scaling to implement the Autoscaler-based architecture.
• B. Use linear scaling to implement the Autoscaler-based architecture
• C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
• D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

Answer: B

Explanation:
Linear scaling is best used with load patterns that change more gradually or have a few large peaks. The method calculates the minimum number of nodes or processing unitsrequired to keep utilization below the scaling threshold. The number of nodes or processing units added or removed in each scaling event is not limited to a fixed step amount.https://cloud.google.com/spanner/docs/autoscaling-overview#linear

NEW QUESTION # 77
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. Disable all foreign key constraints on the source PostgreSQL database.
• B. Shut down the database before the Data Migration Service task is started.
• C. Drop or disable all users except database administration users.
• D. Ensure that all PostgreSQL tables have a primary key.
• E. Ensure that pglogical is installed on the source PostgreSQL database.

Answer: A,E

NEW QUESTION # 78
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

• A. For each application code, set up a common shared user account.
• B. For the application server, set up a service account.
• C. For the application server, set up a common shared user account.
• D. For each application code, set up a dedicated user account.

Answer: B

Explanation:
https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account

NEW QUESTION # 79
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 SQL dump file in Cloud Storage using a temporary instance, and then use that file to import 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 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.
• D. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

Answer: A

Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#serverless

NEW QUESTION # 80
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

• A. Create a streaming Datatlow job to export the table.
• B. Set up Cloud Composer, and create a task to export the table daily.
• C. Use Cloud Scheduler and Cloud Functions to run the daily export.
• D. Run the cron job on a Compute Engine instance to continue the export.

Answer: C

Explanation:
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

NEW QUESTION # 81
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

• A. Use Dataflow to run the export in text format.
• B. Use Cloud Functions to run the export in text format.
• C. Use Dataflow to run the export in Avro format.
• D. Use Cloud Functions to run the export in Avro format.

Answer: C

Explanation:
https://cloud.google.com/spanner/docs/import-export-overview#file-format

NEW QUESTION # 82
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 SQL dump file in Cloud Storage using a temporary instance, and then use that file to import 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 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.
• D. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

Answer: A

NEW QUESTION # 83
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. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
• B. Use granular instance sizing in Cloud Spanner and Autoscaler.
• C. Use interleaving to co-locate parent and child rows.
• D. Manually scale down the number of nodes after the peak period has passed.

Answer: A

NEW QUESTION # 84
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 Bigtable, and modify your application to offload queries.
• D. Configure Cloud SQL for PostgreSQL read replicas to offload queries.

Answer: B

Explanation:
"sub-millisecond latency" always involves Memorystore. Furthermore, as we are talking about a relational DB (Cloud SQL), BigTable is not a solution to be considered.

NEW QUESTION # 85
......

Authentic Professional-Cloud-Database-Engineer Exam Dumps PDF - Nov-2025 Updated: https://www.testsimulate.com/Professional-Cloud-Database-Engineer-study-materials.html