Pass Google Professional-Cloud-Database-Engineer With PracticeDump Exam Dumps - Updated on Sep-2025
Fully Updated Professional-Cloud-Database-Engineer Dumps - 100% Same Q&A In Your Real Exam
Google Professional-Cloud-Database-Engineer Certification Exam is designed for professionals who have experience in designing, developing, and managing databases on the Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification demonstrates the candidate's ability to design, develop, and manage highly scalable, available, and secure databases on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam covers a wide range of topics, including database design, data modeling, data migration, data synchronization, database security, database performance tuning, and disaster recovery.
To be eligible for the exam, candidates should have at least three years of experience in database administration or development, as well as experience with Google Cloud Platform. Candidates should also have a strong understanding of SQL, database design principles, and data modeling concepts.
NEW QUESTION # 66
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 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. - B. 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. - C. 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. - D. 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.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-run#configurehttps://cloud.google.com/sql/docs/mysql
/connect-run#connection-pools
NEW QUESTION # 67
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 Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
- 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 back up the Oracle databases to Cloud Storage using the Standard Storage class.
- D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
Answer: A
Explanation:
https://www.actifio.com/solutions/cloud/google/
NEW QUESTION # 68
Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?
- A. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
- B. Migrate all the databases to Cloud SQL.
- C. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION # 69
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. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- B. Ask existing users to set their Google password to match their corporate password.
- C. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
- D. Use workload identity federation to impersonate a service account.
Answer: A
NEW QUESTION # 70
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?
- A. Use MongoD8 Atlas with Charts.
- B. Use Firestore with Looker.
- C. Use Bigtable with Looker.
- D. Use Cloud Spanner with Data Studio.
Answer: A
NEW QUESTION # 71
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
- A. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
- B. Set the automated backups to occur every other day to lower the frequency of backups.
- C. Reduce the number of automated backups that are retained to two (2).
- D. Select a different region to store your backups.
Answer: B
NEW QUESTION # 72
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. Set Terraform deletion_protection to true.
- C. Use point-in-time-recovery (PITR) to recover the database.
- D. Rerun terraform apply.
Answer: B
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 # 73
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure.
You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?
- A. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
- B. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
- C. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
- D. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
Answer: A
Explanation:
The best answer is deploy an HA configuration and have a read replica you could promote to the primary in a different region
NEW QUESTION # 74
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?
- A. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
- B. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
- C. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
- D. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
Answer: A
Explanation:
The best answer is deploy an HA configuration and have a read replica you could promote to the primary in a different region
NEW QUESTION # 75
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 Spanner.
- B. Deploy the database using Bigtable.
- C. Use BigQuery, and load data in batches.
- D. Deploy the database using Cloud SQL.
Answer: C
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 data. 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 # 76
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
- A. Perform the gcloud sql operations list command.
- B. Check the cloudsql.googleapis.com/postgres.log instance log.
- C. Use the Google Cloud Console.
- D. Use Cloud Audit Logs to verify the status.
Answer: D
NEW QUESTION # 77
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. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
- B. Use Database Migration Service to migrate your database.
- 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: C
NEW QUESTION # 78
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?
- A. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- B. Verify that the new replica is created automatically.
- C. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
- D. Start the original primary instance and resume replication.
Answer: B
Explanation:
Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization: Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.
NEW QUESTION # 79
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
- A. Use Error Reporting to count, analyze, and aggregate the data.
- B. Use Cloud Debugger to inspect the state of an application.
- C. Use Logs Explorer to analyze log data.
- D. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/diagnose-issues#:~:text=If%20your%20instance%20stops%20responding%20to%20connections%20or%20performance%20is%20degraded%2C%20make%20sure%20it%20conforms%20to%20the%20Operational%20Guidelines
NEW QUESTION # 80
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat a. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?
- A. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
- B. Configure your Cloud SQL instance with high availability enabled.
- C. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
- D. Create your database with one primary node and one read replica in the region.
Answer: C
Explanation:
Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
NEW QUESTION # 81
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. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
- B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
- C. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
- D. Bring DB-1 back online.
Answer: C
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 # 82
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
NEW QUESTION # 83
Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?
- A. Migrate the databases to Cloud Spanner.
- B. Migrate the databases to Cloud SQL, and enable a standby database.
- C. Migrate the databases to Compute Engine using regional persistent disks.
- D. Migrate the databases to Bare Metal Solution for Oracle.
Answer: D
Explanation:
BMS is the only Google database service which supports Oracle aside from GCVE. It allows you to use all native Oracle features including RAC. Since GCVE isn't mentioned, it has to be D - Bare Metal Solution.
NEW QUESTION # 84
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. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
- 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. Create a clone database from a read replica database, and restore the clone into a different zone.
Answer: A
NEW QUESTION # 85
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. View Cloud SQL operations to view historical query information.
- B. White a Logs Explorer query to identify database queries with high execution times.
- C. Review application logs to identify database calls.
- D. Use the Query Insights dashboard to identify high execution times.
Answer: D
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 # 86
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. Close idle connections or restart the instance before beginning the import operation.
- B. Increase the amount of memory allocated to your instance.
- C. Ensure that the service account has the Storage Admin role.
- D. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
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 Traffic Director.
- B. Set up Private Service Connect.
- C. Set up Serverless VPC Access.
- D. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
Answer: D
NEW QUESTION # 88
......
Latest Professional-Cloud-Database-Engineer Exam Dumps - Valid and Updated Dumps: https://testking.practicedump.com/Professional-Cloud-Database-Engineer-exam-questions.html