Which tool’s high availability settings must be checked for this?

An organization with resources on Google Cloud regularly backs up its service capabilities to ensure high availability and reduce the downtime when a zone or instance becomes unavailable owing to zonal outage or memory shortage in an instance. However, as protocol, the organization must frequently test whether these regular backups are configured.

Which tool’s high availability settings must be checked for this?
A . MySQL Database
B . Always on Availability Groups (AGs)
C . SQL Server Database Mirroring (DBM)
D . Google Cloud SQL

View Answer

Answer: D

Explanation:

For an organization with resources on Google Cloud that needs to ensure high availability and reduce downtime, the high availability settings of Google Cloud SQL should be checked. Here’s the detailed explanation:

Google Cloud SQL Overview: Cloud SQL is a fully-managed relational database service for MySQL, PostgreSQL, and SQL Server. It provides high availability configurations and automated backups. High Availability Configuration: Cloud SQL offers high availability through regional instances, which replicate data across multiple zones within a region to ensure redundancy.

Testing Backups: Regularly testing backups and their configurations ensures that the high availability settings are functioning correctly and that data recovery is possible in case of an outage.

Reference: Google Cloud SQL Documentation

High Availability and Disaster Recovery for Cloud SQL