You are implementing a single Cloud SQL MySQL second-generation database that contains business-critical transaction data. You want to ensure that the minimum amount of data is lost in case of catastr

The correct answer is C. Binary logging D. Automated backups. Backups help you restore lost data to your Cloud SQL instance. Additionally, if an instance is having a problem, you can restore it to a previous state by using the backup to overwrite it. Enable automated backups for any instance that contains necessary data. Backups protect you

Submitted by haru.x· Mar 30, 2026Ensuring solution and operations reliability

Question

You are implementing a single Cloud SQL MySQL second-generation database that contains business-critical transaction data. You want to ensure that the minimum amount of data is lost in case of catastrophic failure. Which two features should you implement? (Choose two.)

Options

ASharding
BRead replicas
CBinary logging
DAutomated backups
ESemisynchronous replication

How the community answered

(31 responses)

A
3% (1)
B
13% (4)
C
77% (24)
E
6% (2)

Explanation

Backups help you restore lost data to your Cloud SQL instance. Additionally, if an instance is having a problem, you can restore it to a previous state by using the backup to overwrite it. Enable automated backups for any instance that contains necessary data. Backups protect your data from loss or damage. Enabling automated backups, along with binary logging, is also required for some operations, such as clone and replica creation.

Topics

#Cloud SQL#binary logging#automated backups#data durability

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-ARCHITECT Practice