Google Cloud Professional Cloud Architect — Question 114

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.)

Answer options

• A. Sharding
• B. Read replicas
• C. Binary logging
• D. Automated backups
• E. Semisynchronous replication

Correct answer: C, D

Explanation

Implementing Binary logging (C) allows for point-in-time recovery, ensuring minimal data loss by recording all changes. Automated backups (D) create snapshots of the database, enabling restoration to a previous state after a failure. The other options, while beneficial for scalability or performance, do not directly address the need for data loss prevention in catastrophic scenarios.