Google Professional Data Engineer exam dumps

Google Professional Data Engineer practice question 276 of 279

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

Google Professional Data Engineer Question 276

Select 2Google Cloud Platform

You are designing a highly available relational database solution using Cloud SQL for a critical production application. The application requires automatic failover to minimize downtime in case of a regional failure. Which combination of configuration steps should you implement to meet the requirements?

  1. A

    Enable high availability (HA) for the Cloud SQL instance.

  2. B

    Deploy a read replica in a different region.

  3. C

    Configure automated backups for the Cloud SQL instance.

  4. D

    Configure a failover replica in a different zone within the same region.

  5. E

    Set up replication between Cloud SQL instances in different regions.

Show answer and explanation

Correct answers: A, D

Explanation

For a highly available Cloud SQL setup, enabling high availability (HA) ensures that a failover replica is automatically created in a different zone within the same region. This configuration provides automatic failover to minimize downtime in case of zone-level failures. While cross-region replication or read replicas may enhance disaster recovery or scalability, they do not meet the requirement for automatic failover.

  • A. Correct.

    Enabling high availability (HA) for the Cloud SQL instance ensures that an automatic failover replica is created in a different zone within the same region, minimizing downtime in the event of a failure.

  • B. Incorrect.

    Deploying a read replica in a different region improves read scalability but does not provide automatic failover capabilities.

  • C. Incorrect.

    Configuring automated backups is essential for data recovery but does not provide real-time failover or high availability.

  • D. Correct.

    Configuring a failover replica in a different zone within the same region is part of the high availability (HA) setup in Cloud SQL, which enables automatic failover in case of zone-level failures.

  • E. Incorrect.

    Setting up replication between Cloud SQL instances in different regions can be useful for disaster recovery but does not provide automatic failover for high availability.

Timed practice exam

Take a Google Professional Data 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 Data Engineer practice questions

  1. 277.You are designing a high-availability architecture for an e-commerce application that uses Cloud...
  2. 278.Your organization is running a Cloud SQL MySQL instance to support a critical application. To...
  3. 279.
  4. 1.You are designing a data pipeline in Google Cloud for a healthcare organization that must adhere to...
  5. 2.You are designing a data pipeline that processes sensitive customer data for a financial...
Back to the Google Professional Data Engineer exam dumps