Google Professional Cloud Database Engineer exam dumps

Google Professional Cloud Database Engineer practice question 24 of 259

Professional Cloud Database Engineer. Professional level, Google Cloud. Free question with the correct answer and a full explanation.

Google Professional Cloud Database Engineer Question 24

Select 3Google Cloud Platform

Your organization runs a critical e-commerce application on a MySQL database hosted on Google Cloud SQL. The application must maintain high availability with minimal downtime, even during regional outages, and should have a recovery option to restore data in case of accidental deletion. Which combination of strategies should you implement to meet these requirements?

  1. A

    Enable Cross-Region Replicas for the Cloud SQL instance.

  2. B

    Set up a highly available Cloud SQL instance with automatic failover.

  3. C

    Configure daily backups for the Cloud SQL instance.

  4. D

    Rely exclusively on a single-zone instance since it reduces latency.

  5. E

    Use a Memorystore instance as a cache to reduce database load.

Show answer and explanation

Correct answers: A, B, C

Explanation

To achieve high availability and disaster recovery for the MySQL database, you need to combine strategies that protect against regional outages, zonal failures, and accidental data loss. Cross-Region Replicas provide redundancy across regions, a highly available instance with failover handles zonal outages, and backups enable data restoration. A single-zone instance and a caching layer like Memorystore do not meet these requirements.

  • A. Correct.

    Cross-Region Replicas ensure the database remains available in case of a regional outage, providing high availability across regions.

  • B. Correct.

    Setting up a highly available Cloud SQL instance with automatic failover protects against zonal failures and ensures minimal downtime.

  • C. Correct.

    Daily backups allow you to restore the database to a previous state in case of accidental deletion or corruption, providing disaster recovery capabilities.

  • D. Incorrect.

    Using a single-zone instance reduces latency but introduces a single point of failure, making it unsuitable for high availability or disaster recovery requirements.

  • E. Incorrect.

    Memorystore is useful for caching to improve performance but does not address high availability or disaster recovery requirements for the database.

Timed practice exam

Take a Google Professional Cloud Database Engineer practice test under exam conditions

60 questions in 120 minutes, drawn from this bank, with a score report and a per-question review when you finish.

Start timed exam

More Google Professional Cloud Database Engineer practice questions

  1. 25.Your organization is running a mission-critical e-commerce application on Google Cloud. The...
  2. 26.Your organization is deploying a critical customer-facing application that requires high...
  3. 27.Your company runs a global e-commerce platform that requires high availability, low latency for...
  4. 28.You are designing a database architecture for a global e-commerce platform on Google Cloud. The...
  5. 29.Your company operates a globally distributed e-commerce platform with users across multiple...
Back to the Google Professional Cloud Database Engineer exam dumps