Which two features should you implement?

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.)
A . Sharding
B. Read replicas
C. Binary logging
D. Automated backups
E. Semisynchronous replication

View Answer

Answer: C,D

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.

Reference: https://cloud.google.com/sql/docs/mysql/backup-recovery/backups