312-40 practice question 24 of 25

An organization with resources on Google Cloud regularly backs up its service capabilities to ensure high availability and reduce the downtime when a…

Full set: 147 questions
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?
Answer options
A: MySQL Database
B: Always on Availability Groups (AGs)
C: SQL Server Database Mirroring (DBM)
D: Google Cloud SQL Correct answer
Correct Answer:
D. Google Cloud SQL
Explanation

The scenario describes checking high availability and backup configurations for resources on Google Cloud. Google Cloud SQL is a fully managed relational database service that offers built-in high availability (HA) and automated backup features specifically designed to ensure business continuity and reduce downtime from zonal outages. To test the organization's protocol for backup and HA readiness on Google Cloud, an administrator would directly check the configuration settings of the relevant Google Cloud SQL instances.

Why Incorrect

A. MySQL Database is a database technology, not a specific Google Cloud service. It can be run on GCP, but "Google Cloud SQL" is the managed service.
B. Always on Availability Groups (AGs) are a high-availability feature specific to Microsoft SQL Server, not a native Google Cloud service.
C. SQL Server Database Mirroring (DBM) is a deprecated feature for Microsoft SQL Server high availability, not a Google Cloud tool.

References

- Google Cloud. (n.d.). High availability configuration overview. Cloud SQL for MySQL Documentation. Retrieved from https://cloud.google.com/sql/docs/mysql/high-availability. (This document details how Cloud SQL provides HA through primary and standby instances in different zones.)

- Google Cloud. (n.d.). Overview of backups. Cloud SQL for MySQL Documentation. Retrieved from https://cloud.google.com/sql/docs/mysql/backup-recovery/backups. (This page describes the automated and on-demand backup features that are integral to the service.)

Scroll to Top