CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Google
  5. PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Braindumps (page: 17)

Page 17 of 34
PDF with 132 Questions

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?

  1. Watch Query Insights for long running queries.
  2. Watch the Cloud SQL instance monitor for CPU utilization metrics.
  3. Watch the Cloud SQL recommenders for overprovisioned instances.
  4. Watch Cloud Trace for application requests that are failing.

Answer(s): 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 large for 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



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?

  1. Use Bigtable with multi-region clusters.
  2. Use Memorystore for Redis with multi-zones within a region.
  3. Use Cloud SQL for PostgreSQL with cross-region replicas.
  4. Use Cloud Spanner with multi-region configuration.

Answer(s): C



Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution.
What should you do?

  1. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
  2. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
  3. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
  4. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Answer(s): B

Explanation:

https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr



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?

  1. Set up all read replicas in a different region using asynchronous replication.
  2. Set up all read replicas in the same region as the primary instance with synchronous replication.
  3. 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.
  4. 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.

Answer(s): C

Explanation:

This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1. This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.



Page 17 of 34



Post your Comments and Discuss Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam with other Community members:

muksgreen commented on March 01, 2024
brainstorming excellent
JAPAN
upvote