Certification Topics of Professional-Cloud-Database-Engineer Exam PDF Recently Updated Questions
Professional-Cloud-Database-Engineer Exam Prep Guide: Prep guide for the Professional-Cloud-Database-Engineer Exam
Google Cloud Certified - Professional Cloud Database Engineer certification is a valuable asset for professionals who work with databases on the Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification demonstrates the candidate's skills and expertise in database architecture, data modeling, and data management technologies, and validates their ability to design, deploy, and manage scalable and reliable databases on the Google Cloud Platform. Additionally, this certification can help professionals advance their careers and increase their earning potential by demonstrating their proficiency in a highly sought-after skill set.
Google Professional-Cloud-Database-Engineer certification exam is a rigorous test that requires a deep understanding of Google Cloud Platform's database services. Candidates must have experience with Google Cloud SQL, Cloud Spanner, Cloud Bigtable, and other Google Cloud Platform database services. They should also have a good understanding of database design, data modeling, and database optimization.
Google Professional-Cloud-Database-Engineer certification exam is designed for individuals who are interested in demonstrating their expertise in designing, developing, and managing secure and scalable database solutions on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam is intended for database professionals who have experience with Google Cloud SQL, Cloud Spanner, and Cloud Bigtable, among other Google Cloud database services.
NEW QUESTION # 77
You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?
- A. Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.
- B. Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.
- C. Connect by using the private IP address of the AlloyDB cluster directly from the application.
- D. Connect by using AlloyDB Auth Proxy installed in the GKE cluster.
Answer: C
NEW QUESTION # 78
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
- A. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
- B. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
- D. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Answer: A
Explanation:
The Cloud SQL connectors are libraries that provide encryption and IAM-based authorization when connecting to a Cloud SQL instance. They can't provide a network path to a Cloud SQL instance if one is not already present. Other ways to connect to a Cloud SQL instance include using a database client or the Cloud SQL Auth proxy. https://cloud.google.com/sql/docs/postgres/connect-connectors https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/docs/jdbc-postgres.md
NEW QUESTION # 79
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. Select a different region to store your backups.
- C. Set the automated backups to occur every other day to lower the frequency of backups.
- D. Reduce the number of automated backups that are retained to two (2).
Answer: D
Explanation:
By default, for each instance, Cloud SQL retains seven automated backups, in addition to on-demand backups. You can configure how many automated backups to retain (from 1 to 365). We charge a lower rate for backup storage than for other types of instances. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 80
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?
- A. Use the default app profile with single-cluster routing.
- B. Create a custom app profile with multi-cluster routing.
- C. Create a custom app profile with single-cluster routing.
- D. Use the default app profile with multi-cluster routing.
Answer: A
NEW QUESTION # 81
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.backupAdmin for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader 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: C
Explanation:
https://cloud.google.com/spanner/docs/iam#spanner.backupWriter
NEW QUESTION # 82
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. Create additional read replicas, and partition your analytics users to use different read replicas.
- C. 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.
- D. 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.
- E. Create secondary indexes on the replica.
Answer: B,C
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 # 83
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. Use query tags to add application-centric database monitoring.
- B. Shut down and restart each application.
- C. Write a utility to scan database query logs.
- D. Write a utility to scan application logs.
Answer: C
NEW QUESTION # 84
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. C.Deploy the database using Bigtable.
- B. Deploy the database using Cloud Spanner.
- C. Deploy the database using Cloud SQL.
- D. Use BigQuery, and load data in batches.
Answer: A
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 # 85
You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?
- A. Create a new VPC network in each project, and use VPC Network Peering to connect the two together.
- B. Place both the application VMs and the Cloud SQL instances in the default network of each project.
- C. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.
- D. Use the default networks, and leverage Cloud VPN to connect the two together.
Answer: C
Explanation:
https://groups.google.com/g/google-cloud-sql-discuss/c/M5G5_HPXytY?pli=1
NEW QUESTION # 86
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-west1-b.
Create a read replica in us-east1-c. - B. 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. - C. 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. - D. 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.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery
NEW QUESTION # 87
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 clone database.
- B. Start the original primary instance and resume replication.
- C. Verify that the new replica is created automatically.
- D. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
Answer: D
NEW QUESTION # 88
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 read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- C. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
- D. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
Answer: B
NEW QUESTION # 89
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 Bigtable with default encryption.
- D. Use Cloud Spanner with a customer-managed encryption key (CMEK).
Answer: D
Explanation:
Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.
NEW QUESTION # 90
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 Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
- B. Use Cloud Debugger to inspect the state of an application.
- C. Use Error Reporting to count, analyze, and aggregate the data.
- D. Use Logs Explorer to analyze log data.
Answer: A
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 # 91
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. Review application logs to identify database calls.
- C. White a Logs Explorer query to identify database queries with high execution times.
- D. Use the Query Insights dashboard to identify high execution times.
Answer: D
NEW QUESTION # 92
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 PostgreSQL connection 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 # 93
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud.
While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?
- A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- B. Enable the Cloud SQL Admin API.
- C. Ensure that you are using an external (public) IP address interface.
- D. Check whether your service account has cloudsql.instances.connect permission.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting C because in docs it says
"Make sure to enable the Cloud SQL Admin API. If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL
NEW QUESTION # 94
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 organizations for each database type, and apply policy constraints at the organization level.
- B. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project 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 # 95
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 # 96
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. Disable and remove the external IP address assignment.
- D. Specify an authorized network with the CIDR range of the VM.
Answer: C
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 # 97
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
- A. Set up all read replicas in the same region as the primary instance with synchronous replication.
- B. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
- C. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
- D. Set up all read replicas in a different region using asynchronous replication.
Answer: C
NEW QUESTION # 98
......
2025 New Preparation Guide of Google Professional-Cloud-Database-Engineer Exam: https://freetorrent.actual4test.com/Professional-Cloud-Database-Engineer_examcollection.html