Google Professional Cloud Database Engineer exam dumps

Google Professional Cloud Database Engineer practice question 239 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 239

Select 3Google Cloud Platform

Your organization runs a mission-critical application on a Cloud SQL instance. To ensure high availability and disaster recovery, a failover replica has been configured, and automated backups are enabled. The team wants to periodically test the failover and disaster recovery strategies. Which actions should you take to validate the setup effectively?

  1. A

    Simulate a failover by forcing a manual failover of the Cloud SQL instance.

  2. B

    Test restoring a backup to a new Cloud SQL instance in a different region.

  3. C

    Initiate a high CPU workload on the primary instance to observe failover behavior.

  4. D

    Verify that read replicas automatically become writable during failover.

  5. E

    Perform a regional outage simulation to ensure the failover replica takes over.

Show answer and explanation

Correct answers: A, B, E

Explanation

To effectively test high availability and disaster recovery strategies, it is essential to simulate real-world failure scenarios. This includes testing manual failovers, ensuring that backups can be restored to a new instance in a different region, and simulating regional outages. These actions validate that the setup meets the organization's reliability and recovery objectives.

  • A. Correct.

    Simulating a failover with a manual failover is a valid method to test high availability. This ensures that the failover process works as expected.

  • B. Correct.

    Testing a backup restore to a new instance in a different region validates the disaster recovery strategy, ensuring that backups can be used to recover data in case of a catastrophic failure.

  • C. Incorrect.

    While high CPU workloads can test performance, they are not directly relevant for testing failover or disaster recovery strategies.

  • D. Incorrect.

    Read replicas are not intended to become writable during failover. This is not a valid strategy for testing high availability or disaster recovery.

  • E. Correct.

    Simulating a regional outage is a critical test to ensure that the failover replica can handle the workload when the primary region is unavailable.

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. 240.Your company uses Cloud SQL for a mission-critical application and requires high availability and...
  2. 241.You are a database engineer managing a mission-critical application hosted on Google Cloud using...
  3. 242.Your company uses a Cloud SQL instance for its production database. To ensure high availability,...
  4. 243.Your company runs a mission-critical application on Google Cloud using a Cloud Spanner database. To...
  5. 244.Your company has a global e-commerce application running on Google Cloud, backed by a Cloud SQL...
Back to the Google Professional Cloud Database Engineer exam dumps