Free Google Cloud Certified Professional-Cloud-Database-Engineer Ultimate Study Guide (Updated 144 Questions)

Get to the Top with Professional-Cloud-Database-Engineer Practice Exam Questions

To become certified as a Google Professional-Cloud-Database-Engineer, candidates must demonstrate their proficiency in these areas by passing a rigorous exam. Professional-Cloud-Database-Engineer exam consists of multiple choice and scenario-based questions, and candidates have two hours to complete it. Professional-Cloud-Database-Engineer exam can be taken online, and there are no prerequisites for taking it.

The Google Professional-Cloud-Database-Engineer exam consists of multiple choice and multiple select questions, with a total of 50 questions that must be completed within a time limit of two hours. To pass the exam, candidates must achieve a score of 70% or higher. Professional-Cloud-Database-Engineer exam can be taken online or in-person at a Google Cloud testing center.

To qualify for this certification, candidates must have a deep understanding of database concepts and must have hands-on experience with Google Cloud Platform services like Cloud SQL, Cloud Spanner, and Cloud Bigtable. Candidates must also have experience working with SQL and NoSQL databases, and they must be able to design and implement database solutions that meet specific business requirements. Google Cloud Certified - Professional Cloud Database Engineer certification exam consists of multiple-choice questions and practical scenarios that test the candidate's ability to design and implement database solutions on the Google Cloud Platform. Upon passing the exam, candidates will receive the Google Cloud Certified - Professional Cloud Database Engineer certification, which is recognized globally as a mark of excellence in database engineering.

 

NEW QUESTION # 66
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. Select a different region to store your backups.
• D. Reduce the number of automated backups that are retained to two (2).

Answer: B

NEW QUESTION # 67
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

• A. Use Memorystore for Memcached.
• B. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
• C. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
• D. Use Firestore and ensure that the PersistenceEnabled option is set to true.

Answer: D

Explanation:
https://firebase.google.com/docs/firestore/manage-data/enable-offline

NEW QUESTION # 68
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 Bigtable with multi-region clusters.
• B. Use Cloud SQL for PostgreSQL with cross-region replicas.
• C. Use Cloud Spanner with multi-region configuration.
• D. Use Memorystore for Redis with multi-zones within a region.

Answer: B

NEW QUESTION # 69
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

• A. Apply an instance data management pattern.
• B. Apply a table data management pattern.
• C. Apply a database data management pattern.
• D. Apply a schema data management pattern.

Answer: A

NEW QUESTION # 70
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.editor and roles/spanner.admin
• B. roles/cloudsql.viewer and roles/spanner.databaseUser
• C. roles/cloudsql.client and roles/spanner.databaseReader
• D. roles/cloudsql.instanceUser and roles/spanner.databaseUser

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 # 71
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 Bare Metal Solution for Oracle.
• B. Migrate the databases to Compute Engine using regional persistent disks.
• C. Migrate the databases to Cloud Spanner.
• D. Migrate the databases to Cloud SQL, and enable a standby database.

Answer: A

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 # 72
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 Cloud Trace for application requests that are failing.
• C. Watch the Cloud SQL instance monitor for CPU utilization metrics.
• D. Watch the Cloud SQL recommenders for overprovisioned instances.

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 # 73
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?

• A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
• B. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
• C. Migrate applications and Oracle databases to Compute Engine.
• D. Migrate applications to Cloud SQL.

Answer: A

NEW QUESTION # 74
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. Write a utility to scan database query logs.
• B. Shut down and restart each application.
• C. Write a utility to scan application logs.
• D. Use query tags to add application-centric database monitoring.

Answer: D

Explanation:
https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags

NEW QUESTION # 75
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. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
• C. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
• D. Use linear scaling to implement the Autoscaler-based architecture

Answer: D

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 units required 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 # 76
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. White a Logs Explorer query to identify database queries with high execution times.
• B. Review application logs to identify database calls.
• C. View Cloud SQL operations to view historical query information.
• 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 # 77
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 store backups on tapes on-premises.
• B. Migrate the Oracle databases to Compute Engine, 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 Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.

Answer: D

Explanation:
https://www.actifio.com/solutions/cloud/google/

NEW QUESTION # 78
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-east1-b.
  Create a read replica in us-central1-b.
• C. 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.
• D. 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.

Answer: C

Explanation:
https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery

NEW QUESTION # 79
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-1, and re-create DB-1 as a read replica in the same region as DB-1.
• B. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
• C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
• D. Bring DB-1 back online.

Answer: A

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 # 80
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

• A. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
• B. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
• C. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
• D. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

Answer: C

NEW QUESTION # 81
......

Pass Google Professional-Cloud-Database-Engineer exam - questions - convert Tets Engine to PDF: https://www.braindumpsit.com/Professional-Cloud-Database-Engineer_real-exam.html

Use Real Professional-Cloud-Database-Engineer Dumps Free Sample Questions and Practice Test Engine: https://drive.google.com/open?id=1tJgprpQS54njwZGvvXuE4m0zFPIiuKu2