The Best Professional-Cloud-Database-Engineer Exam Study Material and Preparation Test Question Dumps
Get Ready to Pass the Professional-Cloud-Database-Engineer exam Right Now Using Our Google Cloud Certified Exam Package
The Professional-Cloud-Database-Engineer exam is a challenging exam that requires candidates to have a deep understanding of Google Cloud databases. Candidates need to invest time and effort to prepare for the exam. Google Cloud offers a range of training courses, practice exams, and study guides to help candidates prepare for the exam. Candidates can also join the Google Cloud community to connect with other professionals and learn from their experience.
Earning the Google Cloud Certified - Professional Cloud Database Engineer certification can benefit professionals in various ways. It can enhance their credibility and marketability in the job market, as it demonstrates their expertise in a critical area of cloud computing. It can also help them advance their career by opening up new job opportunities or leading to higher salaries.
NEW QUESTION # 80
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 Bigtable with default encryption.
- C. Use Cloud Spanner with a customer-managed encryption key (CMEK).
- D. Use Cloud SQL with a customer-managed encryption key (CMEK).
Answer: D
NEW QUESTION # 81
Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?
- A. Select Bare Metal Solution for Oracle.
- B. Select Bigtable.
- C. Select Cloud Spanner.
- D. Select Cloud SQL.
Answer: C
Explanation:
The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases.
NEW QUESTION # 82
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use the mysqldump utility and binary logs.
- B. Use external server replication.
- C. Use Cloud SQL for MySQL external replica.
- D. Use Data Migration Service.
Answer: D
NEW QUESTION # 83
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. Set the automated backups to occur every other day to lower the frequency of backups.
- B. Reduce the number of automated backups that are retained to two (2).
- C. Select a different region to store your backups.
- D. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
Answer: B
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 # 84
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 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. - B. 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. - C. 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. - D. 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.
Answer: C
Explanation:
https://cloud.google.com/database-migration/docs/mysql/configure-source-database To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.
NEW QUESTION # 85
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. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
- C. Create a read replica, and then use the mysqldump utility to export each table.
- D. Use the mysqldump utility on the primary database instance to export the backup.
Answer: A
Explanation:
https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports
NEW QUESTION # 86
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. Enable the Cloud SQL Admin API.
- B. Check whether your service account has cloudsql.instances.connect permission.
- C. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- D. Ensure that you are using an external (public) IP address interface.
Answer: A
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 # 87
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?
- A. Use Cloud Spanner with multi-region configuration.
- B. Use Memorystore for Redis with multi-zones within a region.
- C. Use Cloud SQL for PostgreSQL with cross-region replicas.
- D. Use Bigtable with multi-region clusters.
Answer: C
NEW QUESTION # 88
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 one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- B. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- C. Create one regional Cloud SQL instance with a read replica in another region.
- D. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
Answer: A
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 # 89
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. Enable the Cloud SQL Admin API.
- B. Check whether your service account has cloudsql.instances.connect permission.
- C. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- D. Ensure that you are using an external (public) IP address interface.
Answer: A
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 # 90
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 Cloud Spanner.
- 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 Compute Engine.
Answer: B
NEW QUESTION # 91
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
- A. Use Database Migration Service to replicate tables into BigQuery.
- B. Use Cloud SQL federated queries.
- C. Develop a custom data replication service to send data into BigQuery.
- D. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
Answer: D
Explanation:
"Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. Datastream supports change data streaming from Oracle and MySQL databases to Google Cloud Storage (GCS). The service offers streamlined integration with Dataflow templates to power up to date materialized views in BigQuery for analytics, replicate their databases into Cloud SQL or Cloud Spanner for database synchronization, or leverage the event stream directly from GCS to realize event-driven architectures."
NEW QUESTION # 92
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. 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. - B. 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. - C. 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. - D. 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.
Answer: D
NEW QUESTION # 93
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.viewer and roles/spanner.databaseUser
- B. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- C. roles/cloudsql.client and roles/spanner.databaseReader
- D. roles/cloudsql.editor and roles/spanner.admin
Answer: A
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 # 94
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. Modify the database schema, and add additional indexes.
- C. Decrease the number of processing units.
- D. Increase the number of processing units.
Answer: D
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 # 95
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 dat a. 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. Queue up all the requested reports in PubSub, and execute the reports at night.
- D. Create a read replica for the Sales Reporting application.
Answer: B
NEW QUESTION # 96
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 Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
- C. Define a connection string using a database username and password to point to the internal (private) 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 # 97
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
Explanation:
Cloud Trace doesn't support Cloud SQL. Eliminate D. Cloud SQL recommenders for overprovisioned instances would tell you about Cloud SQL instances which are too largefor their workload. Eliminate C.
Monitoring CPU utilization wouldn't tell you why microservice calls are failing. Eliminate B. SQLcommenter integrates with Query Insights. So A is the best answer. https://cloud.google.com/blog/topics/developers- practitioners/introducing-sqlcommenter-open-source-orm-auto-instrumentation-library
NEW QUESTION # 98
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
- A. Set your production instance's maintenance window to non-business hours.
- B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
- C. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
- D. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
Answer: B
NEW QUESTION # 99
You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?
- A. Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.
- B. Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.
- C. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage.
Upload the changes into BigQuery, and merge them with existing tables. - D. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.
Answer: D
NEW QUESTION # 100
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.
What should you do? (Choose two.)
- A. Use an external read replica to migrate the databases to Cloud SQL.
- B. Use a read replica to migrate the databases to Cloud SQL.
- C. Use Database Migration Service to migrate the databases to Cloud SQL.
- D. Use a cross-region read replica to migrate the databases to Cloud SQL.
- E. Use replication from an external server to migrate the databases to Cloud SQL.
Answer: C,E
NEW QUESTION # 101
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: C
NEW QUESTION # 102
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. White a Logs Explorer query to identify database queries with high execution times.
- C. Review application logs to identify database calls.
- D. View Cloud SQL operations to view historical query information.
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 # 103
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
- A. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
- B. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- C. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- D. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- E. If the corruption is significant, use import and export.
Answer: C,D
Explanation:
https://cloud.google.com/spanner/docs/pitr#ways-to-recover
To recover the entire database, backup or export the database specifying a timestamp in the past and then restore or import it to a new database. This is typically used to recover from data corruption issues when you have to revert the entire database to a point-in-time before the corruption occurred.
This part describes significant corruption - A
To recover a portion of the database, perform a stale read specifying a query-condition and timestamp in the past, and then write the results back into the live database. This is typically used for surgical operations on a live database. For example, if you accidentally delete a particular row or incorrectly update a subset of data, you can recover it with this method.
This describes insignificant corruption case - E
https://cloud.google.com/spanner/docs/pitr https://cloud.google.com/spanner/docs/backup/restore-backup
NEW QUESTION # 104
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. Set up Cloud Composer, and create a task to export the table daily.
- B. Run the cron job on a Compute Engine instance to continue the export.
- C. Use Cloud Scheduler and Cloud Functions to run the daily export.
- D. Create a streaming Datatlow job to export the table.
Answer: C
Explanation:
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler
NEW QUESTION # 105
......
Get Special Discount Offer of Professional-Cloud-Database-Engineer Certification Exam Sample Questions and Answers: https://www.dumpsfree.com/Professional-Cloud-Database-Engineer-valid-exam.html
Enhance Your Career With Available Preparation Guide for Professional-Cloud-Database-Engineer Exam: https://drive.google.com/open?id=1-bi76gPicQTv1mrVnOKkzbOb0rWZO3-n